Page 2 of 14

Re: How to enter data into a panel workfile.

Posted: Wed Apr 11, 2012 8:42 am
by KLau
Here you go - hope you can tell me what the problem is..

Re: How to enter data into a panel workfile.

Posted: Wed Apr 11, 2012 9:05 am
by EViews Gareth
What are your cross-sections?

Re: How to enter data into a panel workfile.

Posted: Wed Apr 11, 2012 9:15 am
by KLau
Greenf is my dependent variable, Localiz & Urbaniz are my two independent variables.
The other ones are control variables.
For Eviews, the problem seems to be that it does not recognize my year-listings in the right manner.

Re: How to enter data into a panel workfile.

Posted: Wed Apr 11, 2012 9:46 am
by EViews Gareth
No, what are your cross-sections. You say you have panel data. Therefore you have a time variable (year), and a cross-section variable. I want to know what your cross-section variable is.

Re: How to enter data into a panel workfile.

Posted: Wed Apr 11, 2012 2:41 pm
by KLau
These are my regions

Re: How to enter data into a panel workfile.

Posted: Wed Apr 11, 2012 2:51 pm
by EViews Gareth
The way a panel is defined is that each observation is uniquely identified by a time period and a cross-section. There is exactly one observation (row) for each combination of year and cross-section.

Your data doesn't have that. There are 30 observations that have the year "2003" and the cross-section "BE10 - Brussel". Thus you cannot structure your workfile as a panel.

Re: How to enter data into a panel workfile.

Posted: Thu Apr 12, 2012 1:23 am
by KLau
Ok, thank you for your answer Gareth.
Do you have any idea which regression would be better?
Maybe regular OLS instead of pooled OLS, or a negative binomial (zero inflated?), or a conditional logit model?
Thanks again.

Re: How to enter data into a panel workfile.

Posted: Fri Apr 13, 2012 12:07 pm
by distressedbydisso
Hi Gareth,

My data in excel is like the first excel file you posted, but it is unbalanced. There time dimension is 31 years for each country but some years are missing for most countries. In this case, how do I enter my unbalanced panel into excel?

Would really appreciate if you could help me out as I am currently stuck with my dissertation.

regards,
Fida

Re: How to enter data into a panel workfile.

Posted: Fri Apr 13, 2012 12:09 pm
by EViews Gareth
EViews should read the unbalanced data from Excel in the same way it would read the balanced data. Just have rows in Excel for the observations that do exist.

Re: How to enter data into a panel workfile.

Posted: Fri Apr 13, 2012 12:39 pm
by distressedbydisso
Thank you so much for your reply Gareth. So for instance it should be done like this:

Country Year Variable 1 Vairable 2
Armenia 1989 xxxxx xxxx
Armenia 1992 xxxxx xxxx
Armenia 1993 xxxxx xxxx

As opposed to like this:

Country Year Variable1 Variable 2
Armenia 1989 xxxx xxxxx
Aremenia 1990 empty empty
Armenia 1991 empty empty
Armenia 1992 xxxx xxxxx
Armenia 1993 xxxx xxxxx


Am I correct in assuming that the first way is right?

Regards,
Fida

Re: How to enter data into a panel workfile.

Posted: Fri Apr 13, 2012 12:59 pm
by EViews Gareth
Yep.

Re: How to enter data into a panel workfile.

Posted: Fri Apr 13, 2012 5:04 pm
by distressedbydisso
Hi Gareth,


Thank you for your help, I was able to figure it out.

One more question:

The panel regressions I am currently running are "The regressions are estimated with fixed effects, using a GLS estimator", as cited by the paper. Would this mean I select fixed effects for both period and cross section?

And for the with GLS estimator bit, do I still use the Least Squares method? If so, what sort of GLS weights should i give: none, cross section, cross section SUR, period or period SUR

Regards,
Fida

Re: How to enter data into a panel workfile.

Posted: Fri Apr 13, 2012 5:13 pm
by EViews Gareth
Can't help with that.

Re: How to enter data into a panel workfile.

Posted: Fri Apr 13, 2012 6:14 pm
by distressedbydisso
Thats alright. Could you tell me if there are any robustness tests for (unbalanced) panel data models?

Re: How to enter data into a panel workfile.

Posted: Mon Apr 16, 2012 8:45 am
by distressedbydisso
Hi Gareth,

My data is now in the format (as above) and has been recognised by Eviews as panel data. If I now want to lag a certain variable by say a year, would Eviews still recognise the unbalanced panel?

So for eg my data is in the format:
Year Country Spread Crisis Dummy Credit growth Dummy
1981 Albania 3 1 1
1984 Albania 2 1 0
1985 Albania 4 1 0
1986 Albania 2 0 1
1990 Albania 7 1 0

And if I want to lag the credit growth dummy by say two years, would it recongnise that there will be no value for 1984? Or would it simply transpose the 1981 value to 1985?

If lagging the variables works in this unbalanced form, could you also tell me the formula/way to lag this?

Thank you so much for your help,
Regards,
Fida