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 |