SUBSET Statement

Adds or modifies selection criteria defined for a view descriptor.

Type: Optional statement
Applies to: view descriptor

Syntax

SUBSET <selection-criteria> ;

Optional Argument

selection-criteria

can be new or modified selection criteria that you want to define for the view descriptor. Only a WHERE statement can be used with the SUBSET statement.

Use SAS variable names in the SAS WHERE statement to specify selection criteria. Any variable specified in the WHERE statement must also be selected in the view descriptor. If your statement includes a date or time representation, use the SAS date or time constant representation, such as '01JAN91'D.
To improve performance, use WHERE statements from which the IMS engine can generate SSAs. For more information about creating efficient view descriptors, see Performance and Efficient View Descriptors. For more information about the WHERE statement and the expressions that it enables, see SAS Statements: Reference.
You can delete the current selection criteria by issuing the SUBSET statement without an argument.

Details

The SUBSET statement specifies the selection criteria for the view descriptor. If you do not use the SUBSET statement, the view includes all occurrences of the segments included in the view descriptor.