LIST

LIST

Lists columns in the descriptor and gives information about them.

Optional statement

Applies to: access descriptor or view descriptor

Default: ALL

Syntax
Details

Syntax

LIST <ALL | VIEW |<'>column-identifier<'>>;

Details

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 or UPDATE statement and the database connection statements when you create or update a descriptor. You can specify LIST as many times as you want while creating or updating a descriptor; specify LIST last in your PROC ACCESS code to see the entire descriptor. Or, if you are creating or updating multiple descriptors, specify LIST before the next CREATE or UPDATE statement in order to list all the information about the descriptor you are creating or updating.

The LIST statement can take one or more of the following arguments:

ALL

lists all the DBMS columns in the table, the positional equivalents, the SAS variable names, and the SAS variable formats that are available for a descriptor. When you are creating an access descriptor, *NON-DISPLAY* appears next to the column description for any column that has been dropped; *UNSUPPORTED* appears next to any column whose data type is not supported by your DBMS interface view engine. When you are creating a view descriptor, *SELECTED* appears next to the column description for columns that you have selected for the view.

VIEW

lists all the DBMS columns that are selected for the view descriptor, along with their positional equivalents, their SAS names and formats, and any subsetting clauses. Any columns that were dropped in the access descriptor are not displayed. The VIEW argument is valid only for a view descriptor.

column-identifier

lists the specified DBMS column name, its positional equivalent, its SAS variable name and format, and whether the column has been selected. If the column name contains lowercase characters, special characters, or national characters, enclose the name in quotes.

The column-identifier argument can be either the column name or the positional equivalent, which 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 the following statement:

list 5;

You can use one or more of these previously described arguments in a LIST statement, in any order.

Chapter Contents
Previous
Next
Top of Page

	Optional statement
Applies to:	access descriptor or view descriptor
Default:	ALL