Lists columns in the descriptor and gives information about them
| Default: | ALL |
|---|---|
| Restrictions: | You can use this statement only when you create an access descriptor or a view descriptor. |
| Changes that were made since the last CREATE, UPDATE, or RUN statement are not saved. Changes are saved only when a new CREATE, UPDATE, or RUN statement is submitted. | |
| Interactions: | applies to access or view descriptors |
| To review the contents of an existing view descriptor, use the CONTENTS procedure. | |
| Notes: | LIST information is written to your SAS log. |
When you use LIST for an access descriptor, *NON-DISPLAY* appears
next to the column description for any column that has been dropped
and *UNSUPPORTED* appears next to any column
if your DBMS interface view engine does not support the data type.
When you use LIST for a view descriptor, *SELECTED* appears
next to the column description for columns that you have selected
for the view. |
|
| Tip: | Specify LIST last in your PROC ACCESS code to see the entire descriptor. If you create or update multiple descriptors, specify LIST before each CREATE or UPDATE statement to list information about all descriptors that you are creating or updating. |
lists all DBMS columns in the table, positional equivalents, SAS variable names, and SAS variable formats that are available for a descriptor.
lists all DBMS columns that are selected for a view descriptor, their positional equivalents, their SAS names and formats, and any subsetting clauses.
lists information about a specified DBMS column, including its name, positional equivalent, SAS variable name and format, and whether it has been selected. If the column name contains lowercase characters, 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. This is the number that represents the column's place in the descriptor. For example, to list information about the fifth column in the descriptor, submit this statement:
list 5;