topic Re: Panal data - sorting of the data in SAS Procedures

Panal data - sorting of the data

deleted_user — Thu, 09 Apr 2009 10:18:17 GMT

Hey,
I'm new to SAS and i need to carry out a panel data. I have a dataset with 3000 different companies, over 5 years and 7 variables. I imported the dataset from excel in the following order:
NAME YEAR DEPVAR EXVAR1 EXVAR2 ...
comp1 2003 2335 569 ...
comp1 2004 2569 7856
comp1 2005 459 ...
comp1 2006 6359
comp1 2007 4589
comp2 2003 6.357
comp2 2004 7896
comp2 2005 783
comp2 2006 891
comp2 2007 456
...

i sorted the data by name and year without any problems

then i wanted to carry out a panel procedure and got the following message:
ERROR: There is only one cross section or time series observation. Computations will be terminated.

anyone know what I did wrong? Do i have to declare that YEAR is a "year" to recognise the times series? any ideas???

thanks a lot
Fabienne

Re: Panal data - sorting of the data

sbb — Thu, 09 Apr 2009 12:22:02 GMT

I would recommend that you share some of your SAS log output (pasted in a forum reply) and confirm that you have successfully loaded your data, possibly with PROC MEANS or PROC FREQ.

Scott Barry
SBBWorks, Inc.

PROC PANEL documentation from SAS support http://support.sas.com/ website:

http://support.sas.com/documentation/cdl/en/etsug/60372/HTML/default/panel_toc.htm

Re: Panal data - sorting of the data

deleted_user — Thu, 09 Apr 2009 15:23:53 GMT

Thanks for the help!
this is the SAS log after a sorting and freq procedure.

16 Proc sort data=MP.Balanced;
17 by NAAM JAAR;
18 Run;

NOTE: Input data set is already sorted, no sorting done.
NOTE: PROCEDURE SORT used (Total process time):
real time 0.00 seconds
cpu time 0.01 seconds

19 Proc freq data=MP.Balanced;
20 run;

NOTE: There were 14930 observations read from the data set MP.BALANCED.
NOTE: PROCEDURE FREQ used (Total process time):
real time 7.90 seconds
cpu time 1.62 seconds

I hope this is what you needed?

Re: Panal data - sorting of the data

sbb — Thu, 09 Apr 2009 17:44:47 GMT

Not really - I was hoping that you had already taken steps to validate the loading of your data into SAS, either using PROC FREQ or MEANS -- the OUTPUT window or the SASLIST output will have the FREQ reports for you to review. I'd say that it's going to be up to you to do the validation. Also, for others to review with the procedure, you should post your SAS log output from the failure reported.

Scott Barry
SBBWorks, Inc.