I'm running SAS 9.4 TS Level 1M3. I have a macro called FILTER_DATA. I use it to create smaller data sets by filtering SASHELP.CLASS. %macro filter_data(sex, index, age1, age2, age3);
data class_&sex._&index;
set sashelp.class; if sex = "&sex";
if age = &age1 or age= &age2 or age = &age3;
run;
%mend; My challenge is to loop through many applications of FILTER_DATA. Instead of explaining how I want to loop them, it's easier just to show you. %FILTER_DATA(M, 1, 11, 12, 13);
%FILTER_DATA(M, 2, 12, 13, 14);
%FILTER_DATA(M, 3, 13, 14, 15);
%FILTER_DATA(F, 1, 11, 12, 13);
%FILTER_DATA(F, 2, 12, 13, 14);
%FILTER_DATA(F, 3, 13, 14, 15); What code can implement all 6 lines in a loop?
... View more