BookmarkSubscribeRSS Feed
karanfil
Fluorite | Level 6
Hello All,

I need to run fixed effect two way and run the below code but it always give me error as below. Please help me what is wrong in SAS code.

only one cross section or time series observation. Computations will be terminated. Or     Each observation for time point Year=2009 has a missing value for at least one variable in MODEL statement.

 

proc panel data=csrdir.master10;

   id ticker Year;

    model total_esg_score = LAG_total_esg_score dirperINDdirector ln_boardsize ptcinsider ptcwomen duality ln_companyage roa leverage log_ta ln_mktcap earnings_to_assets / fixtwo;

run;

 

 

 
 
 
1 REPLY 1
sbxkoenk
SAS Super FREQ

Hello,

 

I do not know how an ERROR message can be more explicit and specific. 😀

 

PROC PANEL is meant for time-series cross-sectional data (TSCS-data).

 

Your ID statement is like this :

  • ID cross-section-id time-series-id;

How many tickers do you have? How many years?
Do all tickers and years have (non-missing) data?

 

Thanks,

Koen

hackathon24-white-horiz.png

2025 SAS Hackathon: There is still time!

Good news: We've extended SAS Hackathon registration until Sept. 12, so you still have time to be part of our biggest event yet – our five-year anniversary!

Register Now

Discussion stats
  • 1 reply
  • 865 views
  • 0 likes
  • 2 in conversation