Comparison Operators
BetweenExclusive
returns true if the
first value is within the range defined by the second and third values
(excluding the bounding values).
For example, X
BetweenExclusive(50, 100) returns true if X is greater
than 50 and less than 100.
BetweenInclusive
returns true if the
first value is within the range defined by the second and third values
(including the bounding values).
For example, X
BetweenInclusive(50, 100) returns true if X is greater
than or equal to 50 and less than or equal to 100.
In
returns true if the first value is in the list specified by the second
parameter. Select your list by choosing the values from the
drop-down list or the selector window.
For example, X
In ('A', 'B', 'C') returns true when the value of X is
either A, B, or C.
Note: This operator cannot be used
to compare measures.
Missing
For example, X
Missing returns true if the value of X is missing.
NotBetweenExclusive
returns true if the
first value is outside the range defined by the second and third values
(excluding the bounding values).
For example, X
NotBetweenExclusive(50, 100) returns true if X is less
than 50 or greater than 100.
NotBetweenInclusive
returns true if the
first value is outside the range defined by the second and third values
(including the bounding values).
For example, X
NotBetweenInclusive(50, 100) returns true if X is less
than or equal to 50 or greater than or equal to 100.
NotIn
returns true if the first value is not in the list specified by the second parameter.
Select your list by choosing the values from the drop-down list or the selector window.
For example, X
NotIn ('A', 'B', 'C') returns true when the value of
X is not A, B, or C.
Note: This operator cannot be used
to compare measures.
NotMissing
returns true if the value is not a missing value.
For example, X
NotMissing returns true if the value of X is not missing.
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.
Last updated: January 8, 2019