I have a macro loop that isn't processing in SAS, but error log simply spits back the code to me with no explanations. Program is run from the top so no chance of overwriting or missing data; interestingly enough, the same code worked earlier. Restarting SAS doesn't work either.
Any help? Is it something wrong with the code?
For reference:
%macro loop;
%do i = 2004 %to 2010;
%if &i=2010 %then %let t=8;
%else %let t=12;
%do j = 1 %to &t ;
data work.tda_&i&j;
set work.tda2;
where month(datepart(month_date))=&j and
month((OpenDate))>=&j and
year(datepart(month_date))=&i and
year((OpenDate))=&i and
EAS_Prod Contains 'JUMBO';
run;
proc means data=work.tda_&i&j n sum mean;
class Dimension Cterm ;
var CurBal ;
run;
%end;
%end;
%mend loop;
... View more