BookmarkSubscribeRSS Feed
🔒 This topic is solved and locked. Need further help from the community? Please sign in and ask a new question.
t_ar_taat
Quartz | Level 8

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.

1 ACCEPTED SOLUTION
4 REPLIES 4
t_ar_taat
Quartz | Level 8

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;
novinosrin
Tourmaline | Level 20

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

t_ar_taat
Quartz | Level 8

Thank you so much,%str did work wellSmiley Happy

per_str.png

hackathon24-white-horiz.png

2025 SAS Hackathon: There is still time!

Good news: We've extended SAS Hackathon registration until Sept. 12, so you still have time to be part of our biggest event yet – our five-year anniversary!

Register Now

How to Concatenate Values

Learn how use the CAT functions in SAS to join values from multiple variables into a single value.

Find more tutorials on the SAS Users YouTube channel.

SAS Training: Just a Click Away

 Ready to level-up your skills? Choose your own adventure.

Browse our catalog!

Discussion stats
  • 4 replies
  • 1544 views
  • 0 likes
  • 3 in conversation