Panel or Pool?

For requesting general information about EViews, sharing your own tips and tricks, and information on EViews training or guides.

Moderators: EViews Gareth, EViews Moderator

cmgconsulting
Posts: 38
Joined: Mon Nov 17, 2008 8:25 am

Re: Panel or Pool?

Postby cmgconsulting » Tue Nov 08, 2011 10:34 am

Could you expound upon the process to use contraction? I've run across this same problem many times. Here's an example of what the data may look like...

I'll have weekly population for all of the counties in all 50 states. However, I want to look at the population for the states over time. In excel, I would use a pivot table to segment on states and time and then SUM the population. How would I do this in EViews? Also, what if I want to do "max" for some objects and "sum" for other?

startz
Non-normality and collinearity are NOT problems!
Posts: 3491
Joined: Wed Sep 17, 2008 2:25 pm

Re: Panel or Pool?

Postby startz » Tue Nov 08, 2011 10:46 am

Make a new page structured with dates and states. Then copy the relevant series from the existing page to the new page using paste special, match on date and state. You can specify whether the contraction is done by sum or max (among other options).

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

Re: Panel or Pool?

Postby EViews Gareth » Tue Nov 08, 2011 10:48 am

I'm assuming you have a panel workfile with date and county as the two id-series. Startz's method is correct, but if all you want to do is "look" at the population by states, the easiest thing to do would be to open up the population series, and then click on View->Stats by Classification, and then enter your state variable as the classifying variable, and sum as the statistic you're interested in, rather than making a whole new page.
Follow us on Twitter @IHSEViews

cmgconsulting
Posts: 38
Joined: Mon Nov 17, 2008 8:25 am

Re: Panel or Pool?

Postby cmgconsulting » Tue Nov 08, 2011 11:20 am

Thanks Startz, this is exactly what I was trying to do. Much appreciated.

kafeel
Posts: 1
Joined: Fri Mar 09, 2012 11:27 pm

Panel or Pool?

Postby kafeel » Fri Mar 09, 2012 11:44 pm

Hi
I have a problem in estimating the fixed effect model.
As in panel option/effect specification than cross section and period shows none in both cases. Which one take the fixed (Cross-section as fixed or Period as fixed) in estimating the fix model and why?

jomar
Posts: 3
Joined: Tue May 29, 2012 7:07 am

Re: Panel or Pool?

Postby jomar » Tue May 29, 2012 7:20 am

Dear,
I´m a new user (basic user) from eViews.
I'm trying to analyze a group of firms from China.
I've collected three variables from market and analyze them.
So the data are:
Income, income lagged, IFRS (dummy) and interaction IFRS and income lagged.
I have 1507 firms between 2002 and 2011.
So, when I run panel data with fixed or random effects, this error appear: Matrix size error: too many parameters for default coefficient vector.
Could you help me?
Thanks,
Jomar

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

Re: Panel or Pool?

Postby EViews Gareth » Tue May 29, 2012 7:46 am

Which version of EViews are you using, and do you have a panel or a pool?
Follow us on Twitter @IHSEViews

jomar
Posts: 3
Joined: Tue May 29, 2012 7:07 am

Re: Panel or Pool?

Postby jomar » Tue May 29, 2012 8:57 am

I'm using 7.2. I have a pool.

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

Re: Panel or Pool?

Postby EViews Gareth » Tue May 29, 2012 9:05 am

Create your own coefficient vector in the workfile (type the following in the command window:

Code: Select all

coef(2000) beta


Then when you estimate the pool, on the options page change the coefficient name from "c" to the one you just created ("beta" in my example).
Follow us on Twitter @IHSEViews

jomar
Posts: 3
Joined: Tue May 29, 2012 7:07 am

Re: Panel or Pool?

Postby jomar » Tue May 29, 2012 9:21 am

Thank you!

maragloria
Posts: 84
Joined: Tue Jun 29, 2010 7:09 am

Re: Panel or Pool?

Postby maragloria » Wed Feb 13, 2013 12:03 pm

Hi Gareth,

I would like your advice on how should I structure some data.

I got GDP growth and oil consumption for about 80 countries, annually. The 80 countries are split among 4 categories: low income, lower-middle income, upper-middle income, high income.
I would like to run ls regression grouping the countries according to the 4 categories. I’ll run some statistical tests (autocorrelation, unit root, etc) and I might need to do cointegration regression (probably DOLS). Eventually, I would like to use the model to do some forecasts.

My questions are:

- What is the best way to "classify" the countries according to the 4 categories? Dummies?
- Should I structure the data as pool or panel ?

I'm inclined to use panel (because of the forecasting and other estimation facilities) but I'm wondering if the classification is easier to accomplish with pooling.

I’m gonna code the whole procedure in order to facilitate updates as time goes on.

Thanks in advance,

Mara

ticklemedaly
Posts: 3
Joined: Thu Mar 21, 2013 1:31 pm

Re: Panel or Pool?

Postby ticklemedaly » Fri Mar 22, 2013 9:29 am

Hello

I have a concern regarding using a pooled work file. I like to ensure I have corrected my correlation using Newey-West, but the eviews 7 SV doesn't give me the option to include it. Is there another, similar, option within eviews that allows me to correct in a similar manner? Or, is this a limitation within software/methods/theory that I am not aware of?

Thank you for any assistance, and this helpfile greatly explains a lot about the panel/pooled estimation methods within eviews.

Regards,

Ryan

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

Re: Panel or Pool?

Postby EViews Gareth » Fri Mar 22, 2013 9:53 am

Use a panel rather than a pool. Panels support NW.
Follow us on Twitter @IHSEViews

ticklemedaly
Posts: 3
Joined: Thu Mar 21, 2013 1:31 pm

Re: Panel or Pool?

Postby ticklemedaly » Fri Mar 22, 2013 1:04 pm

Thanks! Ill give it a try.

Ryan

yzerman
Posts: 6
Joined: Fri Jun 21, 2013 7:54 am

Re: Panel or Pool?

Postby yzerman » Fri Jun 21, 2013 8:17 am

Many thanks, Gareth, for this insightful post.

I would add one benefit to using a Panel instead of a Pool: when dealing with many cross sections, I find its much quicker to save your workfile in Panel format than in Pool format.

I have more than 3000 cross sections in my file and it takes about 6 minutes for Eviews to save the workfile. It Panel mode it takes 2 seconds. I'm a bit paranoid about losing data so I like to save my files regularly. Waiting 6 minutes each time is a drag on my productivity.


Return to “General Information and Tips and Tricks”

Who is online

Users browsing this forum: No registered users and 1 guest