### Re: How to enter data into a panel workfile.

Posted:

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

Page **2** of **14**

Posted: **Wed Apr 11, 2012 8:42 am**

Here you go - hope you can tell me what the problem is..

Posted: **Wed Apr 11, 2012 9:05 am**

What are your cross-sections?

Posted: **Wed Apr 11, 2012 9:15 am**

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.

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.

Posted: **Wed Apr 11, 2012 9:46 am**

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.

Posted: **Wed Apr 11, 2012 2:41 pm**

These are my regions

Posted: **Wed Apr 11, 2012 2:51 pm**

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.

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.

Posted: **Thu Apr 12, 2012 1:23 am**

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.

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.

Posted: **Fri Apr 13, 2012 12:07 pm**

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

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

Posted: **Fri Apr 13, 2012 12:09 pm**

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.

Posted: **Fri Apr 13, 2012 12:39 pm**

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

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

Posted: **Fri Apr 13, 2012 12:59 pm**

Yep.

Posted: **Fri Apr 13, 2012 5:04 pm**

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

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

Posted: **Fri Apr 13, 2012 5:13 pm**

Can't help with that.

Posted: **Fri Apr 13, 2012 6:14 pm**

Thats alright. Could you tell me if there are any robustness tests for (unbalanced) panel data models?

Posted: **Mon Apr 16, 2012 8:45 am**

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

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