topic How to clean the log for macro variables in New SAS User

How to clean the log for macro variables?

Sami1234 — Fri, 29 Mar 2019 00:36:54 GMT

Wondering if some can help, please?

I am trying to create a decoded variable for any list of variables with the code below.

The code below is creating the variables but also throwing some warnings in the log, would it be possible to remove these warnings.

For example, var1=agegrp and var1dc should be agegrpdc.

I have to keep %let statvar statement, as it will be one of the parameters for a macro variable where i add more variables.

%macro dothis;

%let statvr=agegrp gender ;

%do i = 1 %to %sysfunc(countw(&statvr));

%let seq&i. = %scan(&statvr,&i,%str( ));

%let a=dc;

%let s=%str();

%let seqdc&i.=%sysfunc(catx(&s,&seq&i,%nrstr(%superq(a))));

%let var1 = %scan(&statvr,&i,%str( ));

%end;

%mend;

%dothis;

WARNING: Apparent symbolic reference SEQ not resolved.

novinosrin — Fri, 29 Mar 2019 00:43:35 GMT

a quick look tells me

%let seqdc&i.=%sysfunc(catx(&s,&seq&i,%nrstr(%superq(a))));

&seq&i is incorrect and you need to refer with double &&seq&i

plus you don't need concat functions in macro language for the most part

Sami1234 — Fri, 29 Mar 2019 00:43:44 GMT

Wondering if some can help, please?

I am trying to create a decoded variable for any list of variables with the code below.

The code below is creating the variables but also throwing some warnings in the log, would it be possible to remove these warnings.

For example, var1=agegrp and var1dc should be agegrpdc.

I have to keep %let statvar statement, as it will be one of the parameters for a macro variable where i add more variables.

%macro dothis;

%let statvr=agegrp gender ;

%do i = 1 %to %sysfunc(countw(&statvr));

%let seq&i. = %scan(&statvr,&i,%str( ));

%let a=dc;

%let s=%str();

%let seqdc&i.=%sysfunc(catx(&s,&seq&i,%nrstr(%superq(a))));

%let var1 = %scan(&statvr,&i,%str( ));

%end;

%mend;

%dothis;

WARNING: Apparent symbolic reference SEQ not resolved.

Sami1234 — Fri, 29 Mar 2019 00:48:08 GMT

Thanks allot, its working fine now 🙂