Remove nan

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

nano17440
Posts: 13
Joined: Fri Feb 20, 2015 2:02 pm

Remove nan

Postby nano17440 » Fri Feb 20, 2015 2:05 pm

Hi,

I am trying to remove the nan in different series i have.
I used the following code : X=@recode(X=na,0,X)
However, how can i do it once for all the series ?

Thanks in advance

EViews Gareth
Fe ddaethom, fe welon, fe amcangyfrifon
Posts: 13604
Joined: Tue Sep 16, 2008 5:38 pm

Re: Remove nan

Postby EViews Gareth » Fri Feb 20, 2015 4:01 pm

You'll have to write an EViews program that loops through every series in the workfile and does that. Something like:

Code: Select all

group mygrp * for !i=1 to mygrp.@count %nm = mygrp.@seriesname(!i) {%nm} = @recode({%nm}=na, 0, {%nm}) next


Return to “Data Manipulation”

Who is online

Users browsing this forum: No registered users and 2 guests