Lists information about the variables to be loaded.
|
Optional statement
|
| Default: |
ALL
|
|
LIST <ALL | FIELD |
variable-identifier>;
|
The LIST
statement lists information about all or some of the
SAS variables to be loaded into the new DBMS table. By default, the list
is sent to the SAS log.
The LIST statement can take the ALL, FIELD, or variable-identifier arguments:
- ALL
- lists information about all the variables
in the input SAS data set, whether or not those variables are selected for
the load.
- FIELD
- lists information about only the input SAS
variables that are selected for the load.
- variable-identifier
- lists information about only the specified
variable. The variable-identifier argument can
be either the SAS variable name or the positional equivalent. The positional
equivalent is the number that represents the variable's position in the data
set. For example, if you want to list information for the column associated
with the third SAS variable, submit the following statement:
list 3;
You can specify LIST as many times as
you want while creating a DBMS table; specify LIST before the LOAD statement
to see the entire table. LIST must be specified after the database connection
statements. See LOAD
for more information.
Copyright 1999 by SAS Institute Inc., Cary, NC, USA. All rights reserved.
