|The EXPORT Procedure|
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 database files
Microsoft Excel workbook files
Lotus 1-2-3 spreadsheet 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
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. The DATA step or the SAS/ACCESS code that the EXPORT procedure generates is written to the log. If a translation engine is used, no code is submitted.
To export data, you can 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.