Selecting a Subset of Data

A database would not be very efficient if all logical entries had to be accessed when you needed data from only some of them. SYSTEM 2000 enables you to specify a where-clause to identify those parts of the database that are relevant to your query or update.
A where-clause consists of the keyword WHERE (or WH) and one or more specific conditions that values must meet. Usually, a condition consists of a schema item, an operator, and a value or a range of values. For example:
    WHERE ACCRUED VACATION EXISTS
    WHERE SEX EQ MALE
    WHERE BIRTHDAY SPANS 01/01/1949 * 12/31/1949
    WHERE STREET ADDRESS CONTAINS /RIM ROCK/
You can also combine conditions by using connector operators to form expressions. For example:
    WHERE SKILL TYPE = COBOL AND 
    YEARS OF EXPERIENCE = 4
For the SAS/ACCESS interface to SYSTEM 2000, you can include a SYSTEM 2000 where-clause in a view descriptor to specify selection criteria. In addition to or instead of a SYSTEM 2000 where-clause, you can specify selection criteria in a SAS program by using a SAS WHERE clause.
Note: The SYSTEM 2000 where-clause and the WHERE clause in SAS are different. For example, in a SYSTEM 2000 where-clause, the date format (by default) is MM/DD/YYYY, and you do not have to include single quotes around character strings.