i have a dataset:eco which has some variables like a_1 a_2 a_3, etc.. this is what I want to get: 1, %macro aa; data final_d; do m = 1 to 100; set eco(keep=a_&m); /*&m doesn't work here, any good way to have macro variable to keep the dynamic m value?*/ end; run; %mend; %aa; i know if i change to: 2, %macro aa; data final_d; %do m = 1 %to 100; set eco(keep=a_&m); %end; run; %mend; %aa; i can get the variables a_1 to a_100 very easily. but since the old code used lots of m in the program, i don't want to change. so any good way that I can get a_1 to a_100 in code 1, which I don't change do to %do, but to get the macro variables? thank you.
... View more