 |
|
| The 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 can include such files as Microsoft Access Databases, Microsoft Excel Workbooks, Lotus spreadsheets, and delimited files. 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 File ![[arrow]](../../../../common/63294/HTML/default/images/arrow.gif){kind=icon}
Export Data. For more information about the
Export Wizard, see the Base SAS online Help and documentation.
|
|
Copyright © 2010 by SAS Institute Inc., Cary, NC, USA. All rights reserved.