ACCESS Procedure Reference |
Lists occurrences for repeating data fields.
Optional statement |
|
Applies to: |
access descriptor or view descriptor
|
LISTOCC <">column-identifier-1<"> <...
<">column-identifier-n<">>;
|
The LISTOCC statement lists all the occurrences
for the specified repeating fields along with information such as the CA-Datacom/DB level,
the SAS column name, the occurrence number, the SAS column format and informat,
the DB content, 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.
The LISTOCC statement takes the following argument:
-
column-identifier
-
can be either the CA-Datacom/DB field
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;
If the DBMS column name contains special characters
or national characters, enclose the name in quotation marks. The column-identifier
must be a repeating field.
Copyright © 2007 by SAS Institute Inc., Cary, NC, USA. All rights reserved.