@Quentin What if both Zip and Zip_Plus is missing?  ... View more

@Tom  May I know how to tweak/extend the following code to handle both the conditions at the same time? Both Zip and Zip_Pllus is character datatype.   I want to do this, catx('-',ZIP,ZIP_PLUS) only when ZIP and/or ZIP_PLUS is missing or NULL.     case when not missing(zip) then catx('-',ZIP,ZIP_PLUS) else ' ' end as PRO_ZIP length=10     ... View more

I want to remove CR, LF and leading and trailing spaces in the string. With this code, I could see only '123' in the third observation instead of '123 456'.   I don't want to remove the spaces between the words  or string.     data have; input id $; datalines; 1234 234 123 456 123 ; run; data want; set have; array varnames _character_; do i=1 to dim(varnames); varnames(i)=trim(left(compress(varnames(i),'090A0C0DA0'x))); end; drop i; run; Excepted result:       1234 234 123 456 123     Also I'd like to know how to achieve this using PRXCHANGE or any other similar function. ... View more

@PaigeMiller  Sample data which I shown in data step is correct and align with the real life data. Hence I looking for guidance and clarification. ... View more

@PaigeMiller I tried your code with trim and left function but it's not producing the desired results.   data have; input id $; datalines; 1234 234 123 456 !123 ; run; data want; set have; array varnames _character_; do i=1 to dim(varnames); varnames(i)=trim(left(compress(varnames(i),'090A0C0DA0'x))); end; drop i; run; Excepted Results:   1234 234 123 456 !23 With your code, I could see only '123' in the third observation instead of '123 456' ... View more

@Kurt_Bremser @PaigeMiller  Can I ignore this NOTE in the log?    NOTE: The array var has the same name as a SAS-supplied or user-defined function. Parentheses following this name are treated as array references and not function references.     60 data want; 61 set want; 62 array var _character_; 63 do i=1 to dim(var); 64 var(i)=compress(var(i),'090A0C0DA0'x); NOTE: The array var has the same name as a SAS-supplied or user-defined function. Parentheses following this name are treated as array references and not function references. 65 end; 66 drop i; 67 run;     How to tweak the COMPRESS function for NOT to remove the spaces within the string? E.g. 'Hello World' should be same as  'Hello World' and NOT  'HelloWorld' ... View more

@PaigeMiller Already tried the below program and it's not working as excepted.  After removing the special characters we have to rename it to the actual variable name. If there are two variables in the dataset then I have to do the same in those two variables.   data have; input id $; datalines; 124 5 6 7 $1k09~ ; run; data want; set have; array var _character_; do i=1 to dim(var); var(i)=compress(var(i),'090A0C0DA0'x); end; run; Excepted results:   1245 67 ... View more

@PaigeMiller  I don't want to create any new variables as part of this step.  How to rename the variable 'i' to actual variable name? ... View more

@Kurt_Bremser In real life value for the macro variable parameter_2 comes from webpage and we are adding quotes and separator for SAS to process the list of values. After processing, I was asked to get the value of macro  variable in other new  macro variable (test in my case)  separated by slash  '/'.   Because original macro variable  parameter_2 will go through multiple processing after the steps I shown in the original post. So this new macro variable 'test' will tell us the values for which the job is being processed.  ... View more

@Kurt_Bremser  This is the second question and connected with the original post. I did removed the macro function and used compress but still ended up with this error. You can ignore previous question as it led to confusion.   data _null_; /*test = '/'||&parameter_2||'/'; */ test =cats( '/', catx('/',compress(&parameter_2,'kas')) , '/'); put test=; run;   Value of Parameter_2 is "Medical Insurance"~"Left Atrial Appendage (LAA)"   Log: 81 data _null_; 82 /*test = '/'||&parameter_2||'/'; */ 83 test =cats( '/', catx('/',compress(&parameter_2,'kas')) , '/'); NOTE: Line generated by the macro variable "PARAMETER_2". 83 "Medical Insurance"~"Left Atrial Appendage(LAA)" -------------------------------------- 22 76 ERROR 22-322: Syntax error, expecting one of the following: <, <=, =, >, >=, EQ, GE, GT, LE, LT, NE, NG, NL, ^=, ~=. ERROR 76-322: Syntax error, statement will be ignored.   Excepted result:   /Medical Insurance/Left Atrial Appendage (LAA)/ ... View more

@Kurt_Bremser  I want to add quotes in the previous step. Any help to tweak the below program to generate the result with quote but with slash  (/).   data _null_; /*test = '/'||&parameter_2||'/'; */ test =cats( '/', catx('/',%unquote(&parameter_2)) , '/'); put test=; run; Desired results:   /"Medical Insurance"/"Left Atrial Appendage (LAA)"/ ... View more