EXPORT Procedure

Overview: Export Procedure

PROC EXPORT reads data from a SAS data set and writes it to an external data source. External data sources include delimited files and JMP files. If you have a license for SAS/ACCESS Interface to PC Files, you can also export to such files as Microsoft Access Databases, Microsoft Excel Workbooks, DBF files, and Lotus spreadsheets. In delimited files, a delimiter such as a blank, comma, or tab separates columns of data values.
The EXPORT procedure uses one of these methods to export data:
  • generated DATA step code
  • generated SAS/ACCESS code
  • translation engines
You control the results with options and statements 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 log displays the DATA step or the SAS/ACCESS code that the EXPORT procedure generates. If a translation engine is used, then no code is submitted.
You can also use the Export Wizard to guide you through the steps to export a SAS data set. The Export Wizard can generate EXPORT procedure statements, which you can save to a file for subsequent use. To open the Export Wizard, from the SAS windowing environment, select Filethen selectExport Data. For more information about the Export Wizard, see the Base SAS online Help and documentation.