I am trying to read in multiple datasets that are stored by year/grade. I have a macro which works to read in all the grades for the first year, but fails to continue onto the second year. Can anyone give some suggestions as to what might be happening here? I am getting no errors, just termination after creategrade runs through the loop 6 times.
%macro createyear(num);
%LET year = 97;
%DO I = 1 %to #
%macro creategrade(howmany);
%LET grade = 3;
%DO I = 1 %to &howmany;
data eog&grade.pub&year._1;
set eogsing2.eog&grade.pub&year._1;
stdread=readscal;
stdmath=mathscal;
proc standard data=eog&grade.pub&year._1 mean=0 std=1 out=eog&grade.pub&year._1;
var stdread stdmath;
run;
%LET grade =%eval(&grade+1);
%END;
%mend creategrade;
%creategrade(6);
%LET year =%eval(&year+1);
%END;
%mend createyear;
%createyear(2);