Conditions and Operators for Filters

In SAS Visual Analytics, filters are based on expressions that contain conditions and operators. Depending on the type of data that is used by the filter, you can select from the following categories of filter conditions and operators:

Conditions for Character Data
=	Specifies that a matching value must match one of the filter values exactly. Note: The match for this condition is case sensitive.
Contains	Specifies that a matching value must contain the filter value.
EndsWith	Specifies that a matching value must contain the filter value at the end of the value.
In	Specifies that a matching value is in the list that you select. To select your list, choose the values from the drop-down list.
Missing	Specifies that a missing value matches the filter.
NotContains	Specifies that a matching value must not contain the filter value.
NotIn	Specifies that a matching value is not in the list that you select. To select your list, choose the values from the drop-down list.
NotMissing	Specifies that a nonmissing value matches the filter.
StartsWith	Specifies that a matching value must contain the filter value at the start of the value.

Conditions for Continuous Numeric Data and Date and Time Data
<>	Specifies that a matching value must not be equal to the filter value.
=	Specifies that a matching value must be equal to the filter value.
<	Specifies that a matching value must be less than the filter value.
<=	Specifies that a matching value must be less than or equal to the filter value.
>	Specifies that a matching value must be greater than the filter value.
>=	Specifies that a matching value must be greater than or equal to the filter value.
Between	Specifies that a matching value must be greater than or equal to the first filter value and less than or equal to the second filter value.
Missing	Specifies that a missing value matches the filter.
NotMissing	Specifies that a nonmissing value matches the filter.

Conditions for Discrete Numeric Data and Date and Time Data
<>	Specifies that a matching value must not be equal to the filter value.
=	Specifies that a matching value must be equal to the filter value.
<	Specifies that a matching value must be less than the filter value.
<=	Specifies that a matching value must be less than or equal to the filter value.
>	Specifies that a matching value must be greater than the filter value.
>=	Specifies that a matching value must be greater than or equal to the filter value.
Between	Specifies that a matching value must be greater than or equal to the first filter value and less than or equal to the second filter value.
In	Specifies that a matching value is in the list that you select. To select your list, choose the values from the drop-down list.
NotIn	Specifies that a matching value is not in the list that you select. To select your list, choose the values from the drop-down list.
Missing	Specifies that a missing value matches the filter.
NotMissing	Specifies that a nonmissing value matches the filter.

Operators for All Data Types
AND	Joins two or more conditions and specifies that a matching value must match all of the conditions.
NOT	Specifies that a matching value must not match the expression that follows NOT.
OR	Joins two or more conditions and specifies that a matching value must match at least one of the conditions.

Copyright © SAS Institute Inc. All rights reserved.