Filtering and Sorting Data

In the table viewer, you can right-click a column heading to filter and sort the data by that column.

The filter options vary depending on the type of column that you have selected. The Add Filter window for a numeric column enables you to specify one or two filter criteria for each column. To add a second filter criterion, click .

The Add Filter window for a character column enables you to select one or more values in the column.

The Add Filter window for a date column enables you to select a date value from a pop-up calendar .

When you create a filter on your data, the filter criteria are displayed at the top of the workspace. You can click to edit the filter and to delete the filter. SAS Studio remembers any filters that you create each time you open the data.