nullinf(X)

Returns N/A if the given value is an infinite value.

Syntax

nullinf(X)

Input

Argument Type Description
X any numeric type A column name

Return Value

Returns N/A if the value in column X is an infinite value (positive or negative). Otherwise, returns the value in column X.

If the value in column X is N/A, the result is N/A.

Sample Usage

X nullinf(X)
1/0 NA
1/5 0.2
0/0 NA
NA NA