ifinf(X;Y)
Returns a specified value when the value in a given column is an infinite value.
Syntax
ifinf(X;Y)Input
| Argument | Type | Description |
|---|---|---|
X |
any numeric type | A column name |
| Y | any numeric type | A scalar value or the name of a column |
Note:
X and Y must be the same type.Return Value
Returns Y if the value in column X is an infinite value
(positive or negative). Otherwise, returns the value in column X. The data
type of the return value is the same as X and Y.
If X is N/A, the result is Y.
Sample Usage
X |
Y |
ifinf(X;Y) |
|---|---|---|
| 1/0 | 9999.0 | 9999 |
| 1/5 | 9999.0 | 0.2 |
| 0/0 | 9999.0 | 9999 |
| NA | 9999.0 | 9999 |
| 0/0 | NA | NA |