topic Macro doesn't work with dataset option in SAS Programming

Macro doesn't work with dataset option

sahoositaram555 — Mon, 15 Mar 2021 07:44:12 GMT

Hello everyone,

I have created a list by %let variables= var1 var2 var3 var4 var5 var6;

would like to use it as below

data _output;

set input(keep=(&variables.)); /*var1--var6 should be taken from here*/

run;

This throws an error but if I do as below, it comes correct.

data _output;

set input;

keep &variables.;

run;

anyone, who has overcame this , please help me know why we can't do like the first step?

PeterClemmensen — Mon, 15 Mar 2021 07:49:21 GMT

Simply loose the inner (). This works

data input;
   array var{10} (1 : 10);
run;

%let variables= var1 var2 var3 var4 var5 var6;

data output;
   set input(keep=&variables.); 
run;

ChrisNZ — Mon, 15 Mar 2021 08:18:42 GMT

Always test your macro-free code before adding the macro layer. Always.

Here the code is invalid.

Shmuel — Mon, 15 Mar 2021 10:59:04 GMT

A macro is just a code generator.

Compare next two codes - the 1st with parenthesis, the 2nd without:

/* 1 */
data output;
  set input (keep=(var1 var2 var3));
run;

/* 2 */
data output;
  set input(keep=var1 var2 var3);
run;

The first code is invalid.