ACCESS Procedure Reference

LIST Statement (Optional)

Lists all or selected items in the descriptor and information about the items.

Applies to:

access descriptors and view descriptors

Syntax

LIST <ALL|VIEW|variable-identifier>;

Details

The LIST statement lists all or selected items in the descriptor and attributes of the items, including their positional equivalents, SYSTEM 2000 component numbers, default SAS variable names based on the first eight non-blank characters of the SYSTEM 2000 item names, and the default SAS formats based on the SYSTEM 2000 data types.

The LIST information is written to your SAS log. However, the SYSTEM 2000 item names are not listed in the log because they can be 40 or more characters in length.

You can use one or more of the following in the LIST statement:

ALL: lists all items and item attributes available for selection in the access descriptor. If an item is dropped when the access descriptor is being created, *NON-DISPLAY* is shown next to the item's description. If an item is selected when a view descriptor is being created, *SELECTED* is shown next to the item's description. If you do not specify an argument, the default is ALL.
VIEW: lists all items and item attributes in the access descriptor that is selected for the view descriptor and any subsetting or ordering criteria. VIEW is valid only when creating a view descriptor.

variable-identifier can be one of the following:

the current SAS name for the item
the positional equivalent, which is the number that represents the item, as specified in the LIST statement
the SYSTEM 2000 C-number of the database item

For example, if you want to list information about the fifth item in the database, submit the following statement:

list 5;

If you want to list all of the items in the database followed by the items selected for the view descriptor, submit the following statement:

list all view;

Note: If you specify a record in a LIST statement, all the data items in that record are listed. [cautionend]

Top of Page