topic Re: How to Use the 'TRANWRD' while creating the Macro Variable? in SAS Programming

How to Use the 'TRANWRD' while creating the Macro Variable?

SASuserlot — Thu, 01 Sep 2022 19:07:36 GMT

I am looking to create macro variable which contains the list of variables from the dataset. I am going to use the same list in different places of my big macro. My requirement is , I want to replace the 'comma' (,) symbol with a one blank space where ever needed. I tried the ' TRANWRD' along with the "%sysfunc" . Unfortunately I can not get the output I am expected. Thank you for your suggestions.

%let havelist= %str(company,month,expenses,adjustment,balance);

%let wantlist = %sysfunc(tranwrd(&havelist,","," "));

* looking &wantlist display as 'company month expenses adjustment balance';

%put &havelist ;
%put &wantlist

Re: How to Use the 'TRANWRD' while creating the Macro Variable?

Reeza — Thu, 01 Sep 2022 19:28:57 GMT

%let havelist= %str(company,month,expenses,adjustment,balance);

%let wantlist = %sysfunc(tranwrd(&havelist,%str(,),%str( )));

* looking &wantlist display as 'company month expenses adjustment balance';

%put &havelist ;
%put &wantlist;

Re: How to Use the 'TRANWRD' while creating the Macro Variable?

Kc2 — Thu, 01 Sep 2022 19:31:54 GMT

try this code;

%let havelist= %str(company,month,expenses,adjustment,balance);

%let wantlist = %sysfunc(tranwrd(%quote(&havelist),%str(,),%str( )));

* looking &wantlist display as 'company month expenses adjustment balance';

%put &havelist ;
%put &wantlist;

Re: How to Use the 'TRANWRD' while creating the Macro Variable?

SASuserlot — Thu, 01 Sep 2022 19:39:15 GMT

It worked. thank you @Reeza @Kc2 . %str making the difference? we need to use the '%str' in these scenarios? how to use if there is double space needed instead of single space? Can I use like below double space between double quotes in the second %str option.

%let wantlist = %sysfunc(tranwrd(&havelist,%str(,),%str(" ")));

Re: How to Use the 'TRANWRD' while creating the Macro Variable?

Reeza — Thu, 01 Sep 2022 19:39:43 GMT

Yes, quotes aren't required in macro functions so you need to mask the string in another way.

Re: How to Use the 'TRANWRD' while creating the Macro Variable?

SASuserlot — Thu, 01 Sep 2022 19:40:43 GMT

Thank you.

Re: How to Use the 'TRANWRD' while creating the Macro Variable?

Tom — Thu, 01 Sep 2022 23:46:00 GMT

@SASuserlot wrote:

I am looking to create macro variable which contains the list of variables from the dataset. I am going to use the same list in different places of my big macro. My requirement is , I want to replace the 'comma' (,) symbol with a one blank space where ever needed. I tried the ' TRANWRD' along with the "%sysfunc" . Unfortunately I can not get the output I am expected. Thank you for your suggestions.
%let havelist= %str(company,month,expenses,adjustment,balance);
%let wantlist = %sysfunc(tranwrd(&havelist,","," "));

* looking &wantlist display as 'company month expenses adjustment balance';

There are NOT any commas enclosed in double quote characters in &HAVELIST, so the TRANWRD() function will just return the original value.