topic How can I add a underscore at the end of each macro variable in SAS Programming

How can I add a underscore at the end of each macro variable

bayzid — Wed, 26 Apr 2023 03:03:20 GMT

How can I add a underscore at the end of each macro variable?

For example, I have: %LET mvar= var1 var2 var2.. I want mvar to contain var1_ var2_ var2_

Re: How can I add a underscore at the end of each macro variable

Tom — Wed, 26 Apr 2023 03:08:14 GMT

That is adding underscores in the MIDDLE of the VALUE of the macro variable.

If you know that the string only has one space between the words then you can use TRANWRD() function. You will have to use the %SYSFUNC() macro function to use TRANWRD() function in macro code.

%let mvar=%sysfunc(tranwrd(&mvar,%str( ),%str(_ )))_;

If you are worried it might have multiple spaces between the words then use COMPBL() first.

%let mvar=%sysfunc(tranwrd(%sysfunc(compbl(&mvar)),%str( ),%str(_ )))_;

Example

818  %LET mvar= var1   var2   var2 ;
819
820  %let mvar=%sysfunc(tranwrd(%sysfunc(compbl(&mvar)),%str( ),%str(_ )))_;
821
822  %put &=mvar;
MVAR=var1_ var2_ var2_

Re: How can I add a underscore at the end of each macro variable

Ksharp — Wed, 26 Apr 2023 11:54:25 GMT

 %LET mvar= var1   var2   var2 ;

 %let mvar=%sysfunc(prxchange(s/(\w+)/$1_/,-1,&mvar));

 %put &=mvar;