1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35 36 37
|
%macro import(out=,file=,sheet=);
PROC IMPORT OUT=&out
DATAFILE="&file"
DBMS=EXCEL REPLACE;
SHEET="&sheet";
RUN;
%mend;
%macro fin();
%if &sysday=Monday %then %do;
%import(out=data1,file=c:\sas\test,sheet=test);
%import(out=data2,file=c:\sas\test,sheet=test);
%import(out=data3,file=c:\sas\test,sheet=test);
%import(out=data4,file=c:\sas\test,sheet=test);
data table;
set data1-data4;
run;
%end;
%if &sysday=Thursday %then %do;
%import(out=data1,file=c:\sas\test,sheet=test);
%import(out=data2,file=c:\sas\test,sheet=test);
%import(out=data3,file=c:\sas\test,sheet=test);
data table;
set data1-data3;
run;
%end;
%mend;
%fin; |
Partager