ACCESS Procedure

LIST Statement

Lists columns in the descriptor and gives information about them

Default:

ALL

Syntax

Optional Arguments

Details

Syntax

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

Optional Arguments

ALL: lists all DBMS columns in the table, positional equivalents, SAS variable names, and SAS variable formats that are available for a descriptor.

VIEW: lists all DBMS columns that are selected for a view descriptor, their positional equivalents, their SAS names and formats, and any subsetting clauses.

column-identifier

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, 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 this statement:

list 5;

Details

The LIST statement lists columns in the descriptor, along with information about the columns. The LIST statement can be used only when creating an access descriptor or a view descriptor. The LIST information is written to your SAS log.

To review the contents of an existing view descriptor, use the CONTENTS procedure.

When you use LIST for 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 use LIST for a view descriptor, *SELECTED* appears next to the column description for columns that you have selected for the view.

Specify LIST last in your PROC ACCESS code in order 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.