Filter Data in the Table View :: SAS(R) Model Manager 13.1: User's Guide

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 Model 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 clear filter

.

For more information about SQL expressions, see SAS FedSQL Language Reference.