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
Unbalanced Panel Manipulation
Moderators: EViews Gareth, EViews Jason, EViews Steve, EViews Moderator
-
- Fe ddaethom, fe welon, fe amcangyfrifon
- Posts: 13317
- Joined: Tue Sep 16, 2008 5:38 pm
Re: Unbalanced Panel Manipulation
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
-
- Posts: 8
- Joined: Fri Nov 07, 2008 9:22 am
Re: Unbalanced Panel Manipulation
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
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
-
- Fe ddaethom, fe welon, fe amcangyfrifon
- Posts: 13317
- Joined: Tue Sep 16, 2008 5:38 pm
Re: Unbalanced Panel Manipulation
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
Who is online
Users browsing this forum: No registered users and 21 guests