Chapter Contents

Previous

Next
LISTOCC

LISTOCC



Lists occurrences for multiple value fields.

Optional statement
Applies to: access descriptor or view descriptor


Syntax
Details

Syntax

LISTOCC column-identifier-1 <... column-identifier-n>;


Details

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 for more information on the order of statements.

The LISTOCC statement takes the following argument:

column-identifier
The column-identifier 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.


Chapter Contents

Previous

Next

Top of Page

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