Chapter Contents |
Previous |
Next |
LIST |
Valid: | in a DATA step |
Category: | Action |
Type: | Executable |
Syntax | |
Without Arguments | |
Details | |
Comparisons | |
Examples | |
See Also |
Syntax |
LIST; |
Details |
The LIST statement operates only on data that are read with an INPUT statement; it has no effect on data that are read with a SET, MERGE, MODIFY, or UPDATE statement.
In the SAS log, a ruler that indicates column positions appears before the first record listed.
Comparisons |
Action | LIST statement | PUT statement | |
---|---|---|---|
Writes when | at the end of each iteration of the DATA step | immediately | |
Writes what | the input data records exactly as they appear | the variables or literals specified | |
Writes where | only to the SAS log | to the SAS log, the SAS output destination, or to any external file | |
Works with | INPUT statement only | any data-reading statement | |
Handles Hex Values | automatically prints a hexadecimal value if it encounters an unprintable character | represents characters in hexadecimal only when a hex format is given |
Examples |
This example uses the LIST statement to write to the SAS log any input records that contain missing data.
data employee; input ssn 1-9 #3 w2amt 1-6; if w2amt=. then list; datalines; 23456789 JAMES SMITH 356.79 345671234 Jeffrey Thomas . ;
Because of the #3 line pointer control in the INPUT statement, SAS reads three input records to create a single observation. Therefore, the LIST statement writes the three current input records to the SAS log each time a value for W2AMT is missing:
RULE:----+----1----+----2----+----3----+----4----+----5----+---- 9 345671234 10 Jeffrey Thomas 11 . |
The numbers 9, 10, and 11 are line numbers in the SAS log.
See Also |
Statement:
|
Chapter Contents |
Previous |
Next |
Top of Page |
Copyright 1999 by SAS Institute Inc., Cary, NC, USA. All rights reserved.