Hands-On SAS for Data Analysis

CATS, CATT, and CATX

Let's look at the use of the variations of the CAT functions:

Data Joins;A = "This ";B = " is";C = " a test    ";D = " of CAT";Out_Symbol = Compress (A||B||C||D);Out_CAT = Compress (CAT (A, B, C, D));Out_CATS = CATS (A, B, C, D);Out_CATT = CATT (A, B, C, D);SP = '$';Out_CATX = CATX (SP, A, B, C, D);Run;Proc Print Noobs;Var Out_Symbol Out_CAT Out_CATS Out_CATT Out_CATX;Run;

This will result in the following output:

If the goal is to remove all leading and trailing blanks in a string and output a sentence, the CATT function does the job for us. However, depending on the business problem, we can leverage different variations ...