SETNAVALUE

Purpose:

Replaces NaN values in a series with a specified value.

Syntax:

SETNAVALUE(series, value)

series

-

Optional. A series or table, defaults to the current Window.

value

-

A scalar value that replaces all NaN values in the specified series.

Returns:

A series or table.

Example:

W1: {3.5, 5.0, 6.7, nan, 4.0, 8.0}

W2: setnavalue(W1, 0)

 

W2 sets all NaN values in W1 to 0.0 resulting in the series {3.5, 5.0, 6.7, 0.0, 4.0, 8.0}.

Example:

setnavalue(curr, 100)

 

sets all NaN values in the current Window to 100.

Remarks:

See NAFILL to replace NaN values based on neighboring data points.

 

See REMOVENA to delete NaN values.

See Also:

ISNAVALUE

NAFILL

NAVALUE

READTABLE

REMOVENA