topic Re: Leave space(eq Don't compress) after replacement(tranwrd and %sysfunc) in MACRO in SAS Programming

Leave space(eq Don't compress) after replacement(tranwrd and %sysfunc) in MACRO

t_ar_taat — Sun, 30 Apr 2017 08:34:15 GMT

Hi,all

I want change macro variable's value "t-1-1" to "Table 1-1",say,"Table" + space + "1-1"
So I try #1

%let pow=t-1-1;
%let x = %sysfunc(tranwrd(&pow,t,Table ));
%put x=&x;

The %put statement returns "x=Table-1-1"
but I want "x=Table -1-1",which containing space.

Other way I tried is

%let x2 = %sysfunc(tranwrd(&pow,t,%quote(Table ));

but this resulted in ERROR and can't make macro variable.

Please help me! XD

Sincerely.

Re: Leave space(eq Don't compress) after replacement(tranwrd and %sysfunc) in MACRO

Kurt_Bremser — Sun, 30 Apr 2017 09:35:16 GMT

Build the string in a data _null_ step and use call symput. In a data step

tranwrd("&pow","t","Table ")

should work.

Re: Leave space(eq Don't compress) after replacement(tranwrd and %sysfunc) in MACRO

novinosrin — Sun, 30 Apr 2017 09:57:38 GMT

Your second one does work-->

%let x2 = %sysfunc(tranwrd(&pow,t,%quote(Table )));/*add another closing parenthesis*/

%put x=&x2;

I will not recommend using macro execution functions such as quote or bquote and its NR mate in quoting constant text, I'd rather use %str as it is powerful to quote at the time of macro compilation.

%let x2 = %sysfunc(tranwrd(&pow,t,%str(Table )));
%put x=&x2;

Regards,

Naveen Srinivasan

Re: Leave space(eq Don't compress) after replacement(tranwrd and %sysfunc) in MACRO

t_ar_taat — Sun, 30 Apr 2017 10:30:09 GMT

Thank you so much,%str did work well

Re: Leave space(eq Don't compress) after replacement(tranwrd and %sysfunc) in MACRO

t_ar_taat — Sun, 30 Apr 2017 10:34:15 GMT

Thank you so much Kurt,your knowledge work so nice.

%let pow=t-1-1;
data _null_;
 call symput("x",tranwrd("&pow","t","Table "));
run;
%put x is &x;