LINDA ADAM'S SAS TIPS

Exporting Multiple Data Sets to One Spreadsheet

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).

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.

posted by Linda J. Adams @ 11:39 AM