panel data extract

mark · Postby **mark** » Mon Nov 29, 2010 10:30 am

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

EViews Gareth · Postby **EViews Gareth** » Mon Nov 29, 2010 10:34 am

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?

Amber · Postby **Amber** » Fri Nov 25, 2011 6:54 am

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

EViews Gareth · Postby **EViews Gareth** » Fri Nov 25, 2011 8:32 am

Extract it into what?

Amber · Postby **Amber** » Fri Nov 25, 2011 8:53 am

Extract the independent time series for each firm into a new workfile. Thanks!

EViews Gareth · Postby **EViews Gareth** » Fri Nov 25, 2011 10:29 am

A new workfile for each firm?

Amber · Postby **Amber** » Fri Nov 25, 2011 11:12 am

All in the same workfile. Does the unstack work in this senario?

EViews Gareth · Postby **EViews Gareth** » Fri Nov 25, 2011 1:47 pm

Yep, that's exactly what you want to do.

EViews.com