recoding data from all series simultaneously?

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

Lama
Posts: 15
Joined: Tue Oct 28, 2008 12:07 am

recoding data from all series simultaneously?

Postby Lama » Tue Oct 28, 2008 12:35 am

To analyze my data I have to import a .por-file into Eviews, which works just fine. But how can I set all missing values(in all series to NA? EViews Illustrated (p. 56) recommends to use --> Quick/Generate Series...--> Generate Series by Equation (or alternatively @recode). Trouble is, I can't select all the data in one procedure (a wild card (* or ????) doesn't work.. Is there a possibility to recode all my series in the work file at once?

Yours gratefully,

Lama

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

Re: recoding data from all series simultaneously?

Postby EViews Gareth » Tue Oct 28, 2008 8:21 am

There isn't an easy way to do this.

Best thing to do is to write a quick for loop in a program that would loop through your series and recode them one at a time.

Something like:

Code: Select all

group allvars * allvars.drop resid for !i=1 to allvars.count %name = allvars.@seriesname(!i) {%name} = @recode(....) next
Where you fill in the @recode command with the recoding you want to do.
Follow us on Twitter @IHSEViews

Lama
Posts: 15
Joined: Tue Oct 28, 2008 12:07 am

Re: recoding data from all series simultaneously?

Postby Lama » Tue Oct 28, 2008 9:48 am

Thanks, it works great! You really saved my day!


Return to “Data Manipulation”

Who is online

Users browsing this forum: Google [Bot] and 2 guests