topic Need to remove () in macro variable in SAS Programming

Need to remove () in macro variable

fadtt — Wed, 24 Aug 2011 18:04:23 GMT

Hi everyone,

I need assistance in solving this problem. I will like to use macro function to remove the parenthesis in a macro variable.

For example : I have (pat run track club ) as a macro variable &var and i want to use the &var in another code but the () must be off.

I tried using %sysfunc(tranwrd(&var,()%str(),%str() )) but it is not working. My code may be wrong .

Please assist to correct and solve the problem.

Thanks.

data_null__ — Wed, 24 Aug 2011 18:15:52 GMT

Compress has already been suggested, in your other related thread.

7 %let v = (pat run track club);

8 %let v = %sysfunc(compress(%superQ(v),%str(%(%))));

9 %put NOTE: V=&v;

NOTE: V=pat run track club

fadtt — Wed, 24 Aug 2011 19:59:19 GMT

Thanks data_null_ it worked.