You can filter the rows
that are shown on the
Table View page in
either of the following ways:
-
Click
above the table. The
Filter window
appears. Enter a valid SQL expression, and click
Apply.
-
Right-click on a value in the table. SAS Business Rules Manager displays several predefined
filter options. You can select any of these options.
Depending on which option you select, you might be prompted to enter
data values for the query.
The expression that you enter is displayed above the
data table, and the table is filtered accordingly.
To clear the filter
and display the entire table, click
.
For more information
about SQL expressions, see SAS FedSQL Language Reference.