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???
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.