BookmarkSubscribeRSS Feed
deleted_user
Not applicable
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
3 REPLIES 3
sbb
Lapis Lazuli | Level 10 sbb
Lapis Lazuli | Level 10
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
deleted_user
Not applicable
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?
sbb
Lapis Lazuli | Level 10 sbb
Lapis Lazuli | Level 10
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.

sas-innovate-2024.png

Join us for SAS Innovate April 16-19 at the Aria in Las Vegas. Bring the team and save big with our group pricing for a limited time only.

Pre-conference courses and tutorials are filling up fast and are always a sellout. Register today to reserve your seat.

 

Register now!

What is Bayesian Analysis?

Learn the difference between classical and Bayesian statistical approaches and see a few PROC examples to perform Bayesian analysis in this video.

Find more tutorials on the SAS Users YouTube channel.

Click image to register for webinarClick image to register for webinar

Classroom Training Available!

Select SAS Training centers are offering in-person courses. View upcoming courses for:

View all other training opportunities.

Discussion stats
  • 3 replies
  • 609 views
  • 0 likes
  • 2 in conversation