Input Data Feature Goal Use
only part of each record LINESIZE=option in an
INFILE statement.
some but not all records in the file FIRSTOBS=and OBS=
options in an INFILE
statement; FIRSTOBS=
and OBS= system options;
#n line pointer control.
instream data lines control the reading with
special options
INFILE statement with
appropriate options.
starting at a particular column @ column pointer
leading blanks maintain them $CHARw. informat in an
INPUT statement.
a delimiter other than blanks (with list input or modified list input
with the colon modifier)
option, DSD option, or
both in an INFILE
the standard tab character DLM= or DLMSTR=
option in an INFILE
statement; or the
EXPANDTABS option in
an INFILE statement.
missing values (with list input or
modified list input with the colon
create observations without
compromising data
integrity; protect data
integrity by overriding the
default behavior
TRUNCOVER option in
an INFILE statement;
options, DSD option, or
both might also be
For further information about data-reading features, see the INPUT and INFILE
statements in SAS Statements: Reference.
How SAS Handles Invalid Data
An input value is invalid if it has any of the following characteristics:
It requires an informat that is not specified.
It does not conform to the informat specified.
It does not match the input style used. An example is if it is read as standard numeric
data (no dollar sign or informat) but it does not conform to the rules for standard
SAS numbers.
It is out of range (too large or too small).
418 Chapter 19 Reading Raw Data

Get SAS 9.4 Language Reference, 3rd Edition now with the O’Reilly learning platform.

O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.