Managing Your Data in the SAS Windowing Environment

Exporting a Subset of Data

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 File Export Data from the File menu.

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. Note that Standard data source is selected by default.

In this example, Microsoft Excel 97/2000/2002/2003 Workbook is selected.
Click Next to display the Connect to MS Excel window.
In the Workbook field, enter the workbook name 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 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 a filename that will contain the SAS statements.
Click Finish to complete this task.

Top of Page