Page 1 of 1

Remove nan

Posted: Fri Feb 20, 2015 2:05 pm
by nano17440
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

Re: Remove nan

Posted: Fri Feb 20, 2015 4:01 pm
by EViews Gareth
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