Hello everyone I want to make 5 macro variables that contain a list of variables. It doesn't seem to work for me, and I cant figure out why. %let fil = var1;
%let tal = 1;
proc contents data= svar out=varliste varnum;
run;
data var1 var2 var3 var4 var5 ;
set varliste(keep=name varnum);
if varnum in (120, 127:277) then output var1;
if varnum in (121, 278:428) then output var2;
if varnum in (122, 429:579) then output var3;
if varnum in (123, 580:730) then output var4;
if varnum in (124, 731:881) then output var5;
run;
%macro varliste (tal, fil);
proc sql;
select name into :varliste&tal.
from &fil;
run;
%mend varliste;
%varliste (1, var1);
%varliste (2, var2);
%varliste (3, var3);
%varliste (4, var4);
%varliste (5, var5);
%put _user_; I hope someone can help me! Thanks, Ninna
... View more
