specifies the complete
path and filename or fileref for the input file. A fileref is a SAS
name that is associated with the physical location of the output file.
To assign a fileref, use the FILENAME= statement. You can omit the
quotation marks if the filename does not include certain characters such as these:
Restrictions:The IMPORT procedure does not support device types or
access methods for the FILENAME statement except for DISK. For example,
the IMPORT procedure does not support the TEMP device type, which
creates a temporary external file.
When runningSAS/ACCESS on UNIX, to access data stored on a PC server, specify the full
path and filename of the import file. The use of a fileref is not
The IMPORT procedure can import data if the data type
is supported by SAS. SAS supports numeric and character types of data
but not (for example, binary objects). If the data that you want to
import is a type that SAS does not support, the IMPORT procedure might
not import it correctly. In many cases, the procedure attempts to
convert the data to the best of its ability. However, at times this
is not possible.
Interaction:For some input data sources such as a Microsoft
Excel workbook, the first eight rows of data are scanned. The most
prevalent data type (numeric or character) is used for a column. This
is the default. If most of the data in the first eight rows is missing,
SAS defaults to data type (character) and any subsequent numeric data
for that column is set to missing.
Notes:For information about how SAS converts data types, see
the specific information for the data source file format that you
To import DBF files created with Microsoft Visual FoxPro,
you must export to an appropriate dBASE format using Visual FoxPro.
Import the dBASE file to SAS.
See:The FILENAME statement in SAS Statements: Reference.