Editing a Filter Expression
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:
-
From the Data items list, select the data item on which the condition is based.
-
From the Conditions list, select a condition. For a list of the conditions that are available, see Conditions for Filters.
-
Drag and drop the condition onto the expression.
-
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:
-
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.
-
Drag and drop the operator onto the expression.
-
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:
-
Highlight the part of the expression that you want to keep.
-
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 
drop-down list, and then select Show display
text.
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 
next to the item.
next to the item.
Copyright © SAS Institute Inc. All Rights Reserved.
Last updated: January 8, 2019