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
-
-
-
-
-
-
Delimited files contain columns of data values that
are separated by a delimiter such as a blank or a comma.
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
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.