Specifying a HAVING Clause

To add a HAVING clause to a data query:
  1. Click the Having tab.
  2. On the Fields tab, expand the table node, and select the column to use for filtering data. The Output Columns node includes the calculated columns.
    Tip
    You can type in Filter fields to locate the column.
  3. Double-click the column or drag and drop it in the SQL expression area.
  4. (Optional) You can click the Functions tab and select the functions to use with filtering.
  5. For character variables, you can click Unique Values to load the unique values of the column. 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.
  6. Edit the HAVING clause in the SQL expression. The syntax is identical to that shown in step 6 of Specifying a WHERE Clause.
  7. Click the Save button to save the filter.
Copyright © SAS Institute Inc. All rights reserved.