/ Published in: SAS
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).
Expand |
Embed | Plain Text
Copy this code and paste it in your HTML
/*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.*/
URL: http://www.lindasas.blogspot.com/