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 2024

Innovate_SAS_Blue.png

Registration is open! SAS is returning to Vegas for an AI and analytics experience like no other! Whether you're an executive, manager, end user or SAS partner, SAS Innovate is designed for everyone on your team. Register for just $495 by 12/31/2023.

If you are interested in speaking, there is still time to submit a session idea. More details are posted on the website. 

Register now!

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
  • 194 views
  • 0 likes
  • 2 in conversation