proc import out=work.test
datafile='C:\sastest\excelfile.xlsx'
dbms=xlsx replace;
sheet='Sheet1';
run;
proc export data=sashelp.class
outfile='C:\sastest\excelfile2.xlsx'
dbms=xlsx replace;
sheet='Sheet2';
run;
proc import out=work.test
datafile='C:\sastest\excelfile.xlsx'
dbms=xlsx replace;
sheet='Sheet1';
run;
proc export data=sashelp.class
outfile='C:\sastest\excelfile2.xlsx'
dbms=xlsx replace;
sheet='Sheet2';
run;