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:
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.