Editing a Filter Expression

Specify the Filter Name
Edit a Parameter Value
Add a Condition
Add an Operator
Replace an Operator
Add a Global Parameter
Delete Part of an Expression
Subset an Expression
Edit an Expression as Text
Display the Current Expression as Text
Manage the Scratch Area

Specify the Filter Name

To specify a name for the filter, enter a name in the Filter name field. The filter name identifies the advanced filter on the Filters tab.
Note: You cannot specify the name for a basic filter or a data source filter.

Edit a Parameter Value

To edit a parameter value for a condition or operator, select the parameter, and enter a new value. Or, right-click the parameter field, and select Replace with to select a data item or a global parameter.

Add a Condition

To add a new condition:
  1. From the Data items list, select the data item on which the condition is based.
  2. From the Conditions list, select a condition. For a list of the conditions that are available, see Conditions for Filters.
  3. Drag and drop the condition onto the expression.
  4. For any required parameters, select the parameter, and enter a value, or right-click the parameter field, and select Replace with to select a data item.

Add an Operator

To add an operator to the expression:
  1. From the Operators list, select the operator that you want to add. For a list of the operators that are available, see Operators for Data Expressions.
  2. Drag and drop the operator onto the expression.
  3. For any required parameters, select the parameter, and enter a value. Or, right-click the parameter field, and select Replace with to select a data item.

Replace an Operator

To replace an operator, drag and drop a new operator onto the existing operator in the expression. You can also right-click an operator in your expression, select Replace Operator with, and then select a new operator.

Add a Global Parameter

To add an existing global parameter to your expression, drag and drop the parameter from the Data Items list onto your expression.
To create a new global parameter, in the expression editor, right-click the Parameter heading in the Data Items list, and then select Create Parameter.For more information about creating global parameters, see Working with Global Parameters.

Delete Part of an Expression

To delete a part of an expression, highlight the part of the expression that you want to delete, right-click, and select Delete or Clear.

Subset an Expression

To subset an expression and delete the remainder:
  1. Highlight the part of the expression that you want to keep.
  2. Right-click, and select Keep Operand. The parts of the expression that were not selected are removed.

Edit an Expression as Text

On the Text tab of the expression editor, you can edit an expression as text code. See Editing a Data Expression in Text Mode.

Display the Current Expression as Text

To display the current expression as text on the Display Text tab, click the Options drop-down list, and then select Show display text.

Manage the Scratch Area

The scratch area of the expression editor enables you to store elements of an expression, and then add them back into the expression as needed.
You can see the contents of the scratch area on the Scratch tab.
To move items to the scratch area, right-click part of the expression, and select Move to Scratch Area. You can also drag and drop items from your expression onto the Scratch tab.
To move an item from the scratch area to your expression, drag and drop the item from the Scratch tab onto your expression.
To delete an item in the scratch area, click the Delete Item button next to the item.
Copyright © SAS Institute Inc. All rights reserved.