/*Each data set will be in a separate worksheet:*/

proc export
data=work.region
outfile="c:\temp\results.xls"
dbms=Excel;
run;
proc export
data=work.county
outfile="c:\temp\results.xls"
dbms=Excel;
run;
proc export
data=work.district
outfile="c:\temp\results.xls"
dbms=Excel;
run;

/*Results.xls will have three worksheets, each one automatically labeled with the name of the data set it was created from.*/

http://www.lindasas.blogspot.com/

It's easy to export several data sets to one Excel spreadsheet with each data set in a separate worksheet.This example exports three SAS data sets (work.region, work.county and work.district) to the same spreadsheet (results.xls).

Exporting Multiple Data Sets to One Spreadsheet

excel

SAS