You should also avoid running multiple steps:
%macro forward;
data analysis30_a;
merge
analysis30
%do i = 1 %to 7;
analysis30 (firstobs=&i+1 keep=annualearn rename=(annualearn=earn_t&i))
%end;
;
run;
%mend;
%forward
In my experience, the merge without by sets variables to missing when one of the datasets gets past eof.
... View more