The IMPORT
procedure reads data from an external data source and writes it to
a SAS data set. External data sources can include:
-
Microsoft Access databases
-
Microsoft Excel workbooks
-
-
-
-
-
-
-
Delimited files contain columns of data values that
are separated by a delimiter, such as a blank, a comma, or a tab.
The SAS variable definitions
are based on the input records. The IMPORT procedure imports the data
using one of the following methods:
-
-
generated
SAS/ACCESS code
-
Customize the results
with statements and options that are specific to the input data source.
The IMPORT procedure generates a SAS data set and writes information
about the import to the SAS log. The DATA step or the
SAS/ACCESS code that the IMPORT procedure
generates is written to the log. If a translation engine is used,
no code is submitted.
To import data, you
can use the Import Wizard. This windowing tool guides you through
the steps to import an external data source. You can request that
the Import Wizard generate IMPORT procedure statements. You can save
these statements for subsequent use. To open the Import Wizard, select
File Import Data from the SAS windowing environment.