The WhereCustomizerDialog for a user's COURSES SAS dataset is shown below. To create a filter to run against this dataset, follow these steps:
In this example, our filter will only pass through rows which have a value of "ROCKVILLE, MD" for the LOCATION column.
If you want to further define the filter by editing it as a WHERE clause expression, click the Edit SQL button and type your changes.
To modify a filter you have already defined, either double-click the filter or select the filter, click the right mouse button, and select Edit. The Filter Edit window appears and displays the filter's current definition, which you can then modify. However, if you have used the Edit SQL button to modify the filter as a WHERE clause expression, the Filter Edit window only allows you to view and edit the filter as an expression.