Chapter Contents |
Previous |
Next |
LIST |
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. You can use the LIST statement 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 statement and the database-description statements when you create a descriptor. You can specify LIST as many times as you want while creating a descriptor; specify LIST last in your PROC ACCESS code to see the entire descriptor. Or, if you are creating multiple descriptors, specify LIST before the next CREATE statement in order to list all the information about the descriptor you are creating.
The LIST statement can take one or more of the following arguments:
*NON-DISPLAY*
appears next to the column description
for any column that has been dropped. When you are creating a view descriptor,
*SELECTED*
appears next to the column description for columns that
you have selected for the view.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 options in a LIST statement, in any order.
Chapter Contents |
Previous |
Next |
Top of Page |
Copyright 1999 by SAS Institute Inc., Cary, NC, USA. All rights reserved.