Page 1 of 1
Replace NA with missing
Posted: Tue Oct 13, 2015 9:54 am
by 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
Re: Replace NA with missing
Posted: Tue Oct 13, 2015 11:33 am
by startz
EViews treats NA as missing. What is it that you are trying to accomplish?
Re: Replace NA with missing
Posted: Wed Oct 14, 2015 6:58 am
by 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.
Re: Replace NA with missing
Posted: Wed Oct 14, 2015 7:03 am
by 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.
Re: Replace NA with missing
Posted: Wed Oct 14, 2015 11:29 am
by EViews Glenn
EViews requires the numeric missing values in the series. You can, however, do a replacement of the text representation on the save