data name;
input time;
cards;
200901
200902
200903
200904
200905
200906
200907
200908
200909
200910
200911
200912
;
run;
data _null_;
set name end=last;
call symput(compress("N_name"||(_N_)),compress(time));
if last then call symput("sum",compress(_n_));
run;
%put &N_name1. &sum.;
%MACRO FREQ();
%DO I=1 %TO &SUM.;
DATA T&&N_NAME&I.I&I.;
SET plants.N3Industry&I.;
IF YYYYMM=&&N_NAME&I. THEN OUTPUT T&&N_NAME&I.I&I.;
RUN;
%END;
%MEND;
%FREQ();
|