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;
My Statistical tools and consulting service
Statsitics, Research Methods, SAS, R, HLM, Rasch model
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;