The LIST statement lists columns
in the descriptor along with information about the columns. The LIST
statement can be used when creating an access descriptor or a view
descriptor. The LIST information is written to your SAS log.
If you use an editing
statement, such as LIST, it must follow the CREATE statement and the
database-description statements when you create a descriptor.
See CREATE Statement for more information
about the order of statements.
You can specify LIST
as many times as you want while creating a descriptor; specify LIST
last in your PROC ACCESS code to see the completed descriptor information.
Or, if you are creating multiple descriptors, specify LIST before
the next CREATE statement to list all the information about the descriptor
that you are creating.
The LIST statement can
take one of the following arguments:
lists all the DBMS
columns in the file, the positional equivalents, the SAS variable
names, and the SAS variable formats that are available for the access
descriptor. When you are creating an access descriptor, *NON-DISPLAY* appears next to the column description
for any column that has been dropped. When you are creating a view
descriptor, *SELECTED* appears next to the
column description for columns that you have selected for the view.
lists all the DBMS
columns that are selected for the view descriptor, along with their
positional equivalents, their SAS names and formats, any subsetting
clauses, and the word *SELECTED* . Any columns
that were dropped in the access descriptor are not displayed. The
VIEW argument is valid only for a view descriptor.
lists the specified
DBMS column name, its positional equivalent, its SAS variable name
and format, and whether the column has been selected or dropped.
If the column name contains special characters or national characters,
enclose the name in quotation marks.
The
column-identifier argument can be either the
column name or the positional equivalent from the LIST statement,
which is the number that represents the column's place in the descriptor.
For example, to list information about the fifth and eighth columns
in the descriptor, submit the following statement:
list 5 8;