Comparison Operators
Between
returns true if the
first value is between the second and third values (inclusive).
For example, (X, 50,
100) returns true if X is between 50 and 100.
In
returns true if the
first value is in the list specified by the second parameter. To select
your list, assign a data item to the first parameter, and then choose
the values from the drop-down list.
For example,
X
In (1,2,3) returns true when the value of X is either
1, 2, or 3.
Note: This operator cannot be used
to compare measures.
Missing
returns true if the
value is a missing value.
NotIn
returns true if the
first value is not in the list specified by the second parameter.
To select your list, assign a data item to the first parameter, and
then choose the values from the drop-down list.
For example,
X
NotIn (1,2,3) returns true when the value of X is not
1, 2, or 3.
Note: This operator cannot be used
to compare measures.
NotMissing
returns true if the
value is not a missing value.
x < y
returns true if the
first value is less than the second value.
x <= y
returns true if the
first value is less than or equal to the second value.
x <> y
returns true if the
first value is not equal to the second value.
x = y
returns true if the
first value is equal to the second value.
x > y
returns true if the
first value is greater than the second value.
x >= y
returns true if the
first value is greater than or equal to the second value.
Copyright © SAS Institute Inc. All rights reserved.