IMPORT Procedure

Restriction: The IMPORT procedure is available for the following operating environments:
  • Windows
  • UNIX
Interaction: All data with the percent sign (%) is considered character data to avoid misinterpretation. Percentage data is considered character data because of the danger of misinterpretation.


DATAFILE="filename" | TABLE="tablename"
OUT=<libref.>SAS data set <(SAS data set options)>
<DBMS=identifier> <REPLACE>;

statements for importing from delimited files
DELIMITER=char | 'nn'x;

statements for importing from JMP files
DBENCODING=12-byte SAS encoding-value ;

Table of Procedure Tasks

Statement Task Example
PROC IMPORT Statement Import an external data file to a SAS data set Ex. 1, Ex. 2, Ex. 3, Ex. 4
DATAROW Statement Start reading data from a specific row in the delimited text file Ex. 3
DBENCODING Statement Indicate the encoding character set to use for the JMP file  
DELIMITER Statement Specify the delimiter that separates columns of data in the input file Ex. 1, Ex. 3, Ex. 4
FMTLIB Statement Save value labels to the specified SAS format catalog  
GETNAMES Statement Generate SAS variable names from the data values in the first record in the input file Ex. 1, Ex. 2
GUESSINGROWS Statement Specify the number of rows of the input file to scan to determine the appropriate data type and length for the columns  
META Statement Save JMP metadata information to the specified SAS metadata set