BookmarkSubscribeRSS Feed
🔒 This topic is solved and locked. Need further help from the community? Please sign in and ask a new question.
MR_Xishuai
Calcite | Level 5

Hi all,

I am having a question about how to run the regression if the dependent variable is a ranking number?

For example, I want to look at what kind of factors will determine a person's education level. So my dependent variable:

EDUCATION= 1: PhD

                      2: Master

                      3: Undergraduate

                      4: High School

                      5: less than high school.


My independent variables are some continuous variables or dummy variables let's say: the person's IQ, his parent's salary...


I know that if the dependent is a dummy variable which has only 1 or 0, I can use Logit/Probit model. And if the dependent variable is categorical and cannot be ordered in any meaningful way, then I could use multinomial logistic regression.

But here the dependent variable has more than 2 categories and it is a rank which mean less value is better (for example, 1 is better than 5).

So how could I run this regression? Thanks a lot for you help.

1 ACCEPTED SOLUTION

Accepted Solutions
M_Maldonado
Barite | Level 11

Hi Xishuai,

SAS regression procs support ordinal targets. If you are using SAS Enterprise Miner, all you need to do is set the role of your variable EDUCATION to target, and the level to ordinal. Then add a Regresion node to perform ordinal logistic regression.

 

If you are not using Enterprise Miner, here a good resource for "ordinal logistc regression".

     link: SAS/STAT(R) 9.2 User's Guide, Example: Ordinal Logistic Regression

 

Good luck!

Miguel

View solution in original post

2 REPLIES 2
M_Maldonado
Barite | Level 11

Hi Xishuai,

SAS regression procs support ordinal targets. If you are using SAS Enterprise Miner, all you need to do is set the role of your variable EDUCATION to target, and the level to ordinal. Then add a Regresion node to perform ordinal logistic regression.

 

If you are not using Enterprise Miner, here a good resource for "ordinal logistc regression".

     link: SAS/STAT(R) 9.2 User's Guide, Example: Ordinal Logistic Regression

 

Good luck!

Miguel

MR_Xishuai
Calcite | Level 5

Hi Miguel,

Thanks a lot for your detailed answer and yes, the ordinal logistic regression is definitely what I want.

Cheers,

Xishuai

sas-innovate-2024.png

Join us for SAS Innovate April 16-19 at the Aria in Las Vegas. Bring the team and save big with our group pricing for a limited time only.

Pre-conference courses and tutorials are filling up fast and are always a sellout. Register today to reserve your seat.

 

Register now!

How to choose a machine learning algorithm

Use this tutorial as a handy guide to weigh the pros and cons of these commonly used machine learning algorithms.

Find more tutorials on the SAS Users YouTube channel.

Discussion stats
  • 2 replies
  • 8138 views
  • 1 like
  • 2 in conversation