Manage Filters by Using the Filters Dialog Box (Relational Version)

Create a Filter

To create and apply a filter:
  1. Select Datathen selectFilters from the main menu bar.
  2. (Optional), select a Predefined filter to import. You can create predefined filters by using SAS Information Map Studio.
    Note: Some predefined filters might not be available, depending on how the filters were created. If the information map does not contain predefined filters, the Predefined drop-down list is not available.
  3. From the Subset drop–down list, select the column that the filter will be based on.
  4. Select a Condition for the filter:
    Filter Conditions
    Condition
    Function
    Is equal to
    a matching value must match the filter value exactly.
    Is not equal to
    a matching value must NOT match the filter value exactly.
    Is less than
    a matching value must be less than the filter value.
    Is greater than
    a matching value must be greater than the filter value.
    Is less than or equal to
    a matching value must be less than or equal to the filter value.
    Is greater than or equal to
    a matching value must be greater than or equal to the filter value.
    Is between
    a matching value must be greater than or equal to the filter's Min value and less than or equal to the filter's Max value.
    Is not between
    a matching value must be less than the filter's Min value or greater than the filter's Max value.
    Is missing
    a matching value must be missing.
    Is not missing
    a matching value must not be missing.
    Contains (character data only)
    a matching value must contain the filter string.
    Like (character data only)
    a matching value must be a "fuzzy match" for the filter string.
    Is before (date and time data only)
    a matching value must be before the selected date or time value.
    Is before or equal to (date and time data only)
    a matching value must be before or equal to the selected date or time value.
    Is after (date and time data only)
    a matching value must be after the selected date or time value.
    Is after or equal to (date and time data only)
    a matching value must be after or equal to the selected date or time value.
  5. Specify a Value for the filter. Depending on the condition that you have selected, you can either enter a value or select a value.
    • If the column that you selected is a category column that contains date/time data, specify one or more of the following: Day, Month, Year, Hour, Minute, Second.
    • If you selected the Is missing condition or the Is not missing condition, you don't need to specify a value.
    • If you selected either the Is between condition or the Is not between condition, specify a minimum value in the Min value field and a maximum value in the Max value field.
  6. If the Filter Combinations section of the Filters dialog box is not visible, click Combinations to expose it.
  7. Click Add to create your new filter.
  8. Click OK to apply the new filter and return to the main Visual Data Explorer page. The new filter is displayed in the Applied Filters viewer.
You can minimize (minimize icon), restore(restore icon), or remove(remove icon) the Applied Filters viewer by using the appropriate buttons.
If you remove the Applied Filters viewer, you can add it by selecting Viewthen selectApplied Filters on the main menu bar.

Edit a Filter

To edit an existing filter:
  1. Select Datathen selectFilters from the main menu bar.
  2. From the Filter Combinations pane, select the filter that you want to edit.
  3. Click Edit to open the filter for editing.
  4. Change the filter values, and then click Update.
  5. Click OK to apply your changes and return to the main Visual Data Explorer page.

Manage Filter Combinations

To manage the interactions between filters:
  1. Select Datathen selectFilters from the main menu bar.
  2. Manage filter interactions by using the buttons beneath the Filter Combinations pane:
    Buttons for the Filter Combinations Pane
    Button
    Function
    AND
    inserts the AND operator between the currently-selected filter and the following filter.
    OR
    inserts the OR operator between the currently-selected filter and the following filter.
    NOT
    inserts the NOT operator before the currently-selected filter.
    Group
    groups two or more filters by enclosing them in parentheses. This button is not accessible unless you select multiple filters from the Filter Combinations panel, using the SHIFT or CTRL key.
    Split
    splits up a group of filters by removing the parentheses around the filters.
    Up
    moves the selected filter up in the list.
    Down
    moves the selected filter down in the list.
  3. Click OK to apply your changes and return to the main Visual Data Explorer page.

Clear Filters

To clear filters:
  1. Select Datathen selectFilters from the main menu bar.
  2. From the Filter Combinations pane, select the filters that you want to remove and then click Delete.
  3. Click OK to apply your changes and return to the main Visual Data Explorer page.