Turn on suggestions

Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.

Showing results for

- Home
- /
- Analytics
- /
- Forecasting
- /
- Inverse mills ratio when the dependent variable is not binary

Options

- RSS Feed
- Mark Topic as New
- Mark Topic as Read
- Float this Topic for Current User
- Bookmark
- Subscribe
- Mute
- Printer Friendly Page

- Mark as New
- Bookmark
- Subscribe
- Mute
- RSS Feed
- Permalink
- Report Inappropriate Content

Posted 06-21-2023 12:08 PM
(193 views)

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

- Mark as New
- Bookmark
- Subscribe
- Mute
- RSS Feed
- Permalink
- Report Inappropriate Content

**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.

- Mark as New
- Bookmark
- Subscribe
- Mute
- RSS Feed
- Permalink
- Report Inappropriate Content

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

- Mark as New
- Bookmark
- Subscribe
- Mute
- RSS Feed
- Permalink
- Report Inappropriate Content

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

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. **

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.