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

Hello,

I have a question and I will be grateful if you can help me,

I am running a regression which I have one dependent variable (ranked from 1 to 6) and several independent variable, which some of them are dummy variables(like gender) and some of them are metric variables like age, and I have some other variables like education which I ranked them .I am using SAS for my research.I used proc logistic for my regression, but it  just considers 3 levels of my dependent variable,(as I mentioned before it has 6 levels).

Would you please help me?

Thanks a lot.

1 ACCEPTED SOLUTION

Accepted Solutions
ballardw
Super User

Possibly some of your dependent variable values only occur with missing values for (some combination of) the indepent variables. The output should tell if some observations were excluded and this could be the reason.

View solution in original post

7 REPLIES 7
SteveDenham
Jade | Level 19

Run a quick cross-tab on your data using PROC FREQ.  While your dependent variable may be allowed to take on values from 1 to 6, it seems that your sample only has three values.

Steve Denham

H_G
Calcite | Level 5 H_G
Calcite | Level 5

Thank you for the answer.

actually I am sure that I have data in all 6 levels.still I have the same problem.

SteveDenham
Jade | Level 19

Time to share a partial dataset, and the code you are using.  I have no idea whatsoever how PROC LOGISTIC would only see three levels if the data actually had six, aside from 's observation that independent variables are missing values, resulting in the cases not being included.  It is why I recommend a cross tab in PROC FREQ to see what might be happening.

If this turns out to be the case, then I would not trust imputation as a method.  Missing values will be imputed based on similarity of cases, but not based on the response variable, since it takes on unique values for missing independent variables.  As a result, bad fit of the imputed dataset to the dependent variable.  I think you will have to choose from the following: A)reduce the number of independent variables so that cases are not excluded, B) consolidate scores, so that the dependent variable takes on only three levels, C)accept the analysis as is.  I would prefer B, as I believe the results will be much easier to interpret.

Steve Denham

ballardw
Super User

Possibly some of your dependent variable values only occur with missing values for (some combination of) the indepent variables. The output should tell if some observations were excluded and this could be the reason.

H_G
Calcite | Level 5 H_G
Calcite | Level 5

Yes you are right,

thanks a lot

but do you know how can I solve this problem?

ballardw
Super User

Only solutions I can think of are to either find values for the missing, possibly by imputation, or remove the offending variables from the model.

H_G
Calcite | Level 5 H_G
Calcite | Level 5

Thanks a lot for your help.

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!

What is ANOVA?

ANOVA, or Analysis Of Variance, is used to compare the averages or means of two or more populations to better understand how they differ. Watch this tutorial for more.

Find more tutorials on the SAS Users YouTube channel.

Discussion stats
  • 7 replies
  • 1835 views
  • 7 likes
  • 3 in conversation