Advanced Search

Return to Snippet

Revision: 43217
at March 19, 2011 07:32 by webonomic
Initial Code 
/*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.*/
Initial URL 
http://www.lindasas.blogspot.com/
Initial Description 
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).
Initial Title 
Exporting Multiple Data Sets to One Spreadsheet
Initial Tags 
excel
Initial Language 
SAS