Panel data analysis

[deleted_user]

I'm new to SAS EG and wanted some help regarding the structure of the data needed to perform panel data analysis on SAS EG. It is a time series Cross sectional panel data analysis

My current data is in this format:

1989 1990 1991
Company
X 12 13 45
Y 8 10 16


I have been told that the data format for panel data analysis on SAS EG should be as follows:

Company
X 1989 12
X 1990 13
X 1991 45

Y 1989 8
Y 1990 10
Y 1991 16

Can you please confirm which format is the right one for panel data analysis on SAS EG ?

Thanks
Ash28

[RichardH_sas]

Do you mean the task "Regression Analysis of Panel Data"? I'm not a time series expert, but my limited experience is that yes, you usually need the data in a "narrow" form for a lot of the time series stuff. Someone else may provide a definitive answer, or you might consider cross-posting this on the Forecasting forum (http://support.sas.com/forums/forum.jspa?forumID=28). If you post there, I'd mention the procedure is TSCSREG.

Tech support could also provide an answer if you need: http://support.sas.com/techsup/contact/

[deleted_user]

Yes, I meant the "Regression analysis of panel data". Thanks for your help.