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

sas-innovate-2026-white.png



April 27 – 30 | Gaylord Texan | Grapevine, Texas

Registration is open

Walk in ready to learn. Walk out ready to deliver. This is the data and AI conference you can't afford to miss.
Register now and lock in 2025 pricing—just $495!

Register now

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