Another @nan question

For questions regarding the import, export and manipulation of data in EViews, including graphing and basic statistics.

Moderators: EViews Gareth, EViews Steve, EViews Moderator, EViews Jason

Martin
Posts: 11
Joined: Wed Apr 08, 2009 12:05 pm

Another @nan question

Postby Martin » Fri May 29, 2009 6:34 am

I have created my historic weather series with daily information over a period of 42 years. Scatter randomly throughout the series are N/A values, after some thought I have decided to replace N/A with the previously known value within the series. Is there any way to do this with an EVIEWS function?

For example something like:

Series x=@nan(y,y(-1))

Sometimes N/A’s are group together for 2 to 5 observations. So I need more then the above example.

trubador
Did you use forum search?
Posts: 1520
Joined: Thu Nov 20, 2008 12:04 pm

Re: Another @nan question

Postby trubador » Fri May 29, 2009 6:50 am

Try this:

Code: Select all

series x = @nan(y,x(-1))

Martin
Posts: 11
Joined: Wed Apr 08, 2009 12:05 pm

Re: Another @nan question

Postby Martin » Fri May 29, 2009 7:04 am

Thank you Trubador. LOL, i was close.


Return to “Data Manipulation”

Who is online

Users browsing this forum: No registered users and 2 guests