Help using Base SAS procedures

how to use 'proc panel' when each cross-section has repeated time point?

Reply
N/A
Posts: 0

how to use 'proc panel' when each cross-section has repeated time point?

hi,buddy,hope you can give me a hand! it's very urgent for me,and thanks in advance.
My sample:
stock reportdate forecasterro marketvalue beta firmexperience analyst
001 2002-01-05 0.66 783749 1.22 0.22 EAHH01
001 2003-12-04 0.24 835455 1.24 0.43 EAHL02
001 2003-12-08 0.32 835353 1.24 0.23 EARY03
001 2004-01--01 0.44 823311 1.25 0.43 EAHL02
001 2004-03-24 0.54 834672 1.43 0.54 EAHH01
002 2002-06-11 0.89 437535 0.99 0.23 EAWW03
002 2002-07-31 0.92 478281 0.89 0.13 EAHH01
002 2003-11-21 0.82 472481 0.89 0.28 EAHH01
........
each analyst provide forecast for each stock,when analysts revised their forecast or othe analyst provide forecast in the same year,there has more than one reportdate in the same year. I want to do regression,where forecasterro is dependent variable,marketvalue,beta,firmexperience are independent variable.
I try to use proc panel,but the log told me there's repeated time point, following is my procedure:

proc sort data=a;
by stock rptdate analyst;
proc panel data=a;
model forecasterro=marketvalue beta firmexperienc/solution noint;
run;

I don't know what to do next,can you help me?thanks again
Ask a Question
Discussion stats
  • 0 replies
  • 102 views
  • 0 likes
  • 1 in conversation