SUBSET

SUBSET

Adds or modifies selection criteria defined for a view descriptor

Optional statement

Applies to: view descriptor

Syntax
Details

Syntax

SUBSET selection-criteria;

Details

The SUBSET statement specifies the selection criteria when creating a view descriptor This statement is optional, but omitting it causes the view to retrieve all the data in the database. For example, you can issue the following statement:

subset "where amount<1010";

If you have multiple selection criteria, enter them all in one SUBSET statement, as in the following example:

subset "where amount<1010"
       "ob amount";

The quoted strings are concatenated and passed to SYSTEM 2000 software for processing.

For more information on selection and ordering criteria for the SAS/ACCESS interface to SYSTEM 2000 data management software, refer to your Release 6.06 SAS/ACCESS documentation.

To clear the selection criteria, issue a SUBSET statement without an argument, as follows:

subset;

Chapter Contents
Previous
Next
Top of Page