EXPORT Procedure Overview

The EXPORT procedure reads data from a SAS data set and writes it to an external data source. External data sources can include:

• Microsoft Access databases

• Microsoft Excel workbooks

• Lotus 1-2-3 spreadsheets

• Paradox files

• SPSS files

• Stata files

• DBF files

• JMP delimited files

The EXPORT procedure reads the input file and writes the data to an external data source. The EXPORT procedure exports the data using one of these methods:

• generated DATA step code

• generated SAS/ACCESS code

• translation engines

You customize the results with statements and options that are specific to the output data source. The EXPORT procedure generates the specified output file and writes information about the export to the SAS log. In the log, you see the DATA step or the SAS/ACCESS code that the EXPORT procedure generates. If a translation engine is used, no code is submitted.

To export data, you can also use the Export Wizard, which is a windowing tool that guides you through the steps to export to an external data source. You can request that the Export Wizard generate EXPORT procedure statements, which you can save for subsequent use. To open the Export Wizard, select File  EXPORT Data from the SAS windowing environment.

Copyright © 2009 by SAS Institute Inc., Cary, NC, USA. All rights reserved.