Specify a WHERE Clause

To add a WHERE clause to a data query:
  1. Click the Where tab.
  2. On the Fields tab, expand the table node, and select the column to use for filtering data.
    Tip
    You can enter a value in the Filter fields field to locate the column.
  3. Double-click the column or drag and drop it in the SQL expression area.
  4. For character variables, you can click column_name Values to view the unique values of the column. In the Filter Values window, select the check boxes to specify the unique values to include in the filter.
    Click Apply to add the unique values to the SQL expression area.
  5. (Optional) You can click the Functions tab and select the functions to use with filtering.
  6. (Optional) You can add a subquery to the filter using a table from a different library. On the Libraries tab, click the Add button to add a library.
    After you select a library, expand the library node, and select the table that you want to use for the subquery.
    Note: In the SQL expression, you must enclose the subquery in parentheses.
  7. Edit the WHERE clause in the SQL expression area as follows:
    Number of Values
    Edit
    Example
    A single character value
    Add an equal sign between the column name and the unique value. 
    CARS.Make = 'Acura'
    More than one character value
    Specify an IN operator and enclose the unique values in parentheses. 
    CARS.Make IN (
'Acura', 'Audi')
    Numeric comparison
    Specify a numeric operator and a constant, or specify a numeric operator and another column name. 
    CARS.Cylinders >= 6
    PRDSALE.Actual > PRDSALE.Estimate
  8. Click the Save button to save the filter.
Copyright © SAS Institute Inc. All rights reserved.