Page 1 of 1
panel data extract
Posted: Mon Nov 29, 2010 10:30 am
by mark
Using 7.1
I have an unbalanced panel data set and need to extract (1) one record in each panel (2) the record with the minimum value. the panel is 660 *3,800
Tried variations of @obsid=@first(projectnum, qty)
Suggestions?
thanks
Re: panel data extract
Posted: Mon Nov 29, 2010 10:34 am
by EViews Gareth
I can't quite visualise what you're doing.
You have a basic panel, with cross-sections and time (I presume). You have a series of data in that workfile. You're trying to create a new workfile page that has cross-sections only, where the time periods have been squashed up to equal the minimal value of the series for each cross-section. Is that right?
Re: panel data extract
Posted: Fri Nov 25, 2011 6:54 am
by Amber
Dear Eviews expert,
I have a similar query: I have an unbalanced panel data set (with cross sectional id and time/date), and I intend to extract the time series for each firm, could you please give me guidance on this?
I really appreciate! :D
Best regards,
Amber
panel data extract
Posted: Fri Nov 25, 2011 8:32 am
by EViews Gareth
Extract it into what?
Re: panel data extract
Posted: Fri Nov 25, 2011 8:53 am
by Amber
Extract the independent time series for each firm into a new workfile. Thanks!
panel data extract
Posted: Fri Nov 25, 2011 10:29 am
by EViews Gareth
A new workfile for each firm?
Re: panel data extract
Posted: Fri Nov 25, 2011 11:12 am
by Amber
All in the same workfile. Does the unstack work in this senario?
panel data extract
Posted: Fri Nov 25, 2011 1:47 pm
by EViews Gareth
Yep, that's exactly what you want to do.