BookmarkSubscribeRSS Feed
GokulK
Calcite | Level 5

Hello Everyone,

 

I need your help with the SAS codes. I need to use a Heckman selection model to correct for endogeneity. In the first stage of my Heckman model, the dependent variable is CEO expertise. Since there are three categories of CEO expertise in my context, the dependent variable (CEO_Expert) takes value either 0,1, or 2 (0 if the CEO is an accounting expert; 1 if a finance expert; and 2 if a sales expert). I don’t know how to obtain inverse mills ratio when the dependent variable is ternary. In the past instances when my dependent variable was a 1/0 dummy, I used proc qlim to obtain inverse mills ratio.

 

PROC QLIM data = First_Stage;

model Y1 = X1 X2 / DISCRETE;

OUTPUT out=Have mills;

RUN;

 

I have seen only examples of using inverse Mills ratio involving binary probit selection equation. I would really appreciate it if someone shared the code to obtain inverse mills ratio when the dependent variable is not binary.

 

Thanks,

Gokul

 

3 REPLIES 3
sbxkoenk
SAS Super FREQ

Mills ratio
The inverse Mills ratio can be computed for censored or truncated continuous responses, binary discrete responses, and endogenous selection variables via the MILLS option in the OUTPUT statement of SAS/ETS PROC QLIM and SAS Viya PROC CQLIM.

GokulK
Calcite | Level 5

Thank you for replying to my post. Will you please share the code that I can use to get the inverse mills ratio when my dependent variable takes values 0,1, & 2? I am a novice and know only basic SAS codes.

 

Thanks,

Gokul

 

sbxkoenk
SAS Super FREQ

Hello,

 

I will further check on Friday (23/06) but I don't think that's possible.

Your 0, 1 & 2 response is neither belonging to censored or truncated continuous responses, nor to binary discrete responses.

 

Is your 0, 1 & 2 response on a nominal scale or on an ordinal scale?

And does inverse Mills ratio exist for multinomial or ordinal response?

Maybe you need a One-vs-Rest or One-vs-One approach (resulting in multiple inverse Mills ratio's).

https://machinelearningmastery.com/one-vs-rest-and-one-vs-one-for-multi-class-classification

 

BR,

Koen

SAS Innovate 2025: Call for Content

Are you ready for the spotlight? We're accepting content ideas for SAS Innovate 2025 to be held May 6-9 in Orlando, FL. The call is open until September 16. Read more here about why you should contribute and what is in it for you!

Submit your idea!

Multiple Linear Regression in SAS

Learn how to run multiple linear regression models with and without interactions, presented by SAS user Alex Chaplin.

Find more tutorials on the SAS Users YouTube channel.

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