space
Previous Page | Next Page

ACCESS Procedure Reference

SUBSET Statement



Adds or modifies selection criteria defined for a view descriptor.
Optional statement
Applies to: view descriptor

Syntax
Details
Arguments

Syntax

SUBSET <selection-criteria>;


Details

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


Arguments

The selection-criteria argument 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 it enables, see SAS Language Reference: Dictionary.

You can delete the current selection criteria by issuing the SUBSET statement without an argument.

space
Previous Page | Next Page | Top of Page