Usage Note 6695: How to export multiple SAS data sets to multiple sheets in Excel
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:
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
SAS/ACCESS Interface to PC Files
Microsoft Windows NT Workstation
Microsoft Windows 95/98
Windows Millennium Edition (Me)
Microsoft Windows 2000 Advanced Server
Microsoft Windows 2000 Datacenter Server
Microsoft Windows 2000 Professional
Microsoft Windows 2000 Server
For software releases that are not yet generally available, the Fixed
Release is the software release in which the problem is planned to be