As the excel type is xlsx I proffered the datastep then the proc import.
Please check next code:
%let year = 2017;
libname excelin xlsx "C:\PCC_Trends\PCC_&year..xlsx";
%macro exec(suffix);
data work.PCC_&year.&suffix;
set excelin.Section&suffix;
run;
proc sort data=work.PCC_&year.&suffix;
by OSHPD_ID;
run;
%mend exec;
%exec(a);
%exec(b);
%exec(c);
%exec(d);
%exec(e);
%exec(f);
data PCC_&year;
merge PCC_&year.a PCC_&year.b PCC_&year.c ;
by OSHPD_ID;
run;
data PCC_&year.nonresp;
merge PCC_&year.d PCC_&year.e PCC_&year.f ;
by OSHPD_ID;
run;
... View more