The Export
Wizard reads data from a SAS data set and writes it to
an external file. You can export SAS data to a variety of formats.
The formats that are available depend on your operating environment
and the SAS products that you have installed.
Export Data
To export data, follow
these steps:
Select FileExport Data.
The Export
Wizard - Select library and member window appears.
Select the SAS data
set from which you want to export data.
In this example, WORK is selected as the library, and FURNSALESSORTED is the member name.
Click Next and the Export Wizard - Select export type window appears.
Select the type of data
source to which you want to export files.
In this example, Microsoft Excel 97/2000/2002/2003 Workbook is selected.
Note that Standard data source is selected
by default.
Click Next to display the Connect to MS Excel window.
In the Workbook field, enter the name of the workbook that will contain the exported
file and then click OK.
In this example, Myworkbook is entered as the name of the workbook.
When the Export Wizard - Select table window appears, enter a
name for the table that you are exporting.
In this example, Mytable is the table name.
Click Next.
If you want SAS to create
a file of PROC EXPORT statements for later use, then enter the name
of the file that will contain the SAS statements.