The DBLOAD Procedure for Relational Databases LIST Statement 319
LIMIT Statement
Limits the number of observations that are loaded
Default: 5000
LIMIT=load-limit;
Details
The LIMIT= statement places a limit on the number of observations that can be
loaded into the new DBMS table. The load-limit argument must be a non-negative
integer. To load all the observations from your input data set, specify
limit=0.
LIST Statement
Lists information about the variables to be loaded
Default:
ALL
LIST <ALL | FIELD | variable-identifier>;
Details
The LIST statement lists information about some or all 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 following 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.
