The NULLIF function compares one expression with another and returns NA when the expressions are equal, or the base expression when they are not.
NA
Return Value
NA when the expressions are equal, or the base expression when they are not.
Syntax
NULLIF (expr1 , expr2)
Parameters
An expression. The base expression for the comparison.
An expression to compare to expr1.
Examples
Example 8-41 Comparing Values Using NULLIF
SHOW NULLIF(1, '1') NA SHOW NULLIF('red', 'Red') red
Scripting on this page enhances content navigation, but does not change the content in any way.