Entering panel-data (cross-sectional time-series data) into SPSS for regression

Posted by fazzmo on Dec 01, 2012; 12:33pm
URL: http://spssx-discussion.165.s1.nabble.com/Entering-panel-data-cross-sectional-time-series-data-into-SPSS-for-regression-tp5716565.html

I am kind of desperate as I dont know how to enter pooled data (I have data about 42 countries over 7 years per variable) into SPSS and then run a simple regression.

So far SPSS does not assign the observations to a certain country and year and rather treats each variable as independent. How do I tell SPSS that I have 42 observations (one for each country) for 7 years per variable and not 294 (7*42) observations?

This is how I arranged it so far:



Do I need to create some Interaction variables (Time*Variable)?

Once I manage to enter this correctly, 4 independent variables (Ease, BusFree, PropRight, Corrup) make up one latent variable which is supposed to have an effect on one dependent variable. I will use SPSS Amos to perform a confirmatory factor analysis and to run a regression, if that's possible.

I would appreciate your help very much as I've been trying to figure this out for days :/ I just need a simple way to get some legitimate results, it does not have to be highly scientific.

Thank you so much in advance.