• Print |
• E-mail  |
• Bookmark

Three programs are now available to export multiple SAS data sets to
multiple sheets in Excel Workbooks. They are available at the
following web address:

http://ftp.sas.com/techsup/download/base

For version 9 use the following code:

MULTISHEETEXPORTER9.SAS - creates and or replaces multiple sheets in Excel.  

For version 8 use the following code:

MACROEXPORTERNEW.SAS creates a new workbook with multiple sheets
from multiple SAS datasets.

MACROEXPORTERNEWSHEETLOOP.SAS creates a new workbook with multiple
sheet names from multiple sas datasets but gives the excel sheet
names in a series, such as sheet1, sheet2, etc.  You can specify
the name of the series.  (Such as balance1, balance2 etc).


MACROEXPORTEREXISTING.SAS updates an existing workbook and can add
multiple sheets from multiple SAS databases. If a sheet already exists
with the same name, an option to replace the sheet or increment the
sheet is available in the program.



These programs should be run on Windows platforms only with Version 8
of the SAS System or later.

Operating System and Release Information