Unbalanced Panel Manipulation

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

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

theodore04
Posts: 8
Joined: Fri Nov 07, 2008 9:22 am

Unbalanced Panel Manipulation

Postby theodore04 » Wed Jul 20, 2011 3:17 am

Dear All,

I have an unbalanced panel and want/wish to make it balanced. Is there a quick way of doing this?

Is there a way of replacing the NA values with the average of the observation before and after or something like this?

regards

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

Re: Unbalanced Panel Manipulation

Postby EViews Gareth » Wed Jul 20, 2011 8:06 am

You can use interpolation (from the Proc menu on a series) to fill in the NAs like that. Its just simple linear interpolation.
Follow us on Twitter @IHSEViews

theodore04
Posts: 8
Joined: Fri Nov 07, 2008 9:22 am

Re: Unbalanced Panel Manipulation

Postby theodore04 » Wed Jul 20, 2011 9:20 am

thanks.

is there any problem when one has a panel dataset?

what happens when for a cross section the first obs is missing?

is there a danger that is using info from the previous cross section?

thanks

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

Re: Unbalanced Panel Manipulation

Postby EViews Gareth » Wed Jul 20, 2011 9:23 am

No, it won't use a value from a previous cross-section. It will remain as an NA (since interpolation requires observations before and after the missing observation, if the first value for a cross-section is missing, it cannot interpolate).
Follow us on Twitter @IHSEViews


Return to “Data Manipulation”

Who is online

Users browsing this forum: No registered users and 3 guests