How to export multiple datasets to a single Excel file and arranging them as Work sheets using proc export.
Do you license SAS/Access for pcfile formats, what version of SAS are you using, what kind of computer are you using, and is it 32 or 64 bit?
SAS EG 4.3
We had access for PC Files.
proc export data=sashelp.class outfile='c:\temp\x.xls' dbms=excel replace;sheet='class';run;
proc export data=sashelp.air outfile='c:\temp\x.xls' dbms=excel replace;sheet='air';run;
If i want to replace only Air Sheet then what i have to do
Just run the code again, air sheet will be updated .