| ACCESS Procedure Reference |
Adds or modifies selection criteria defined for a view descriptor.
| Optional statement |
|
| Applies to: |
view descriptor
|
|
SUBSET
<selection-criteria>;
|
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.
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.
Copyright © 2007 by SAS Institute Inc., Cary, NC, USA. All rights reserved.
