Chapter Contents

Previous

Next

LIST

Optional statement
Applies to:	access descriptor and view descriptor

Details

The LIST statement lists all or selected items in the descriptor and attributes of 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.

Note:   The SYSTEM 2000 item names are not listed in the log because of their possible 40 or more character length.  

The LIST information is written to your SAS log.

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

ALL	lists all items and item attributes available in the access descriptor for selection. If an item has been dropped when creating an access descriptor, *NON-DISPLAY* is shown next to the item's description. When creating a view descriptor, items selected for the view are shown with *SELECTED* 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 selected for the view descriptor and any subsetting or ordering criteria. The VIEW argument is only valid when creating a view descriptor.
variable-identifier	the current SAS name, the positional equivalent (which is the number that represents the item, as given by the LIST statement), or the SYSTEM 2000 C-number of the database item. If you specify a record in a LIST statement, all the data items in that record are listed. For example, if you want to list information about the fifth item in the database, issue 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, issue the following statement:

list all view;

Chapter Contents

Previous

Next

Top of Page

Copyright 1999 by SAS Institute Inc., Cary, NC, USA. All rights reserved.