ACCESS Procedure Reference |
Lists occurrences for multiple value fields.
Optional statement |
|
Applies to: |
access descriptor or view descriptor
|
LISTOCC column-identifier-1 <... column-identifier-n>;
|
The LISTOCC statement lists all
the requested occurrences for the specified multiple-value fields along with
information such as the ADABAS level, the SAS variable name, the occurrence
number, the SAS variable format and informat, the DB content, the descriptor
type, and whether the occurrence has been selected or dropped. The LISTOCC
statement can be used when creating an access descriptor or a view descriptor.
The LISTOCC information is written to your SAS log.
If you use an editing statement, such as LISTOCC, it
must follow the CREATE statement and the database-description statements when
you create a descriptor. See CREATE Statement for more information about the order of statements.
The LISTOCC statement
takes the following argument:
-
column-identifier
-
can be either the column name or the positional
equivalent from the LIST statement, which is the number that represents the
column's place in the descriptor. For example, to list occurrences for the
fifth column in the descriptor, submit the following statement:
listocc 5;
The column-identifier must be a multiple-value field.
Copyright © 2007 by SAS Institute Inc., Cary, NC, USA. All rights reserved.