Boolean Operators
AND
joins two conditions
and returns true if both conditions are true.
For example,
(1 = 1) AND (2 = 2)
returns
true, and
(1 = 1) AND (2 = 1)
returns
false.
IF... ELSE
returns different values,
depending on whether the condition is true. The first parameter specifies
the condition. The second parameter specifies the value to return
if the condition is true. The third parameter specifies the value
to return if the condition is false.
For example,
if (X > Y) return X else Y
returns
the value of X if X is greater than Y, but returns the value of Y
otherwise.
NOT
returns true if the
condition is false.
For example,
not
(1 = 2)
returns true.
OR
joins two conditions
and returns true if either condition is true.
For example,
(1 = 1) OR (2 = 2)
returns
true, and
(1 = 1) OR (2 = 1)
returns
true.
Copyright © SAS Institute Inc. All rights reserved.