Filter Data in the Table View

You can filter the rows that are shown on the Table View page in either of the following ways:
  • Click filter above the table. The Filter window appears. Enter a valid SQL expression, and click Apply.
  • Right-click on a value in the table. SAS Decision 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.
    filter pop-up menu
The expression that you enter is displayed above the data table, and the table is filtered accordingly.
filter above the data table
To clear the filter and display the entire table, click clear filter.
For more information about SQL expressions, see SAS FedSQL Language Reference.