Replace NA with missing

[sfawver@archmi.com]

I'm using EViews9, latest build.

Is there a way to replace NA values with missing? So replace NA with a period.

The error is get is . is not defined in "blah".

series fcst_hpi=@recode(fcst_hpi=na,.,fcst_hpi

[startz]

EViews treats NA as missing. What is it that you are trying to accomplish?

[sfawver@archmi.com]

I would like to replace the NAs in the series with a period. So when I export the series to .csv there won't be any text in the field. It will le me replace it with zero. Just wondering if I can replace it with a period. I'm guessing probably not.

[startz]

You can't replace with a period, because a series only contains numeric values. But you might be able to copy the series into an alpha, and replace missings there with a period.

[EViews Glenn]

EViews requires the numeric missing values in the series. You can, however, do a replacement of the text representation on the save

Code: Select all

wfsave(type=text) test.txt na="."