Apologies if this has been discussed before, I couldn't find a solution through a search.
I want to create a single data step framework that runs inside a macro loop driven by an array of string variables...
As simply as I can put it...
Say I have the array, days{7} sun mon tue wed thu fri sat;
I want to loop a single data step using this array to generate...
data sun; (each new dataset gets its name from the array variable)
set old;
keep var1 var2;
day = sun; (array variable can be used inside data step as well)
run;
data mon;
set old;
keep var1 var2;
day = mon;
run;
...and so on through the entire list of strings. Is this possible? I've been trying to use %DO_OVER but I can't seem to get the format right. Also SCAN has been another dry run. Is it just the case that the macro language does not support arrays, and I should just create separate data steps?
Thanks for any help or advice.
... View more