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.

Syntax

DATAFILE="filename" | TABLE="tablename"

OUT=<libref.>SAS data set <(SAS data set options)>

<DBMS=identifier> <REPLACE>;

statements for importing from delimited files

DATAROW=n;

DELIMITER=char | 'nn'x;

GETNAMES=YES | NO;

GUESSINGROWS=n;

statements for importing from JMP files

DBENCODING=12-byte SAS encoding-value ;

FMTLIB=<libref.>format-catalog;

META=libref.member-data-set;

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