BookmarkSubscribeRSS Feed
okla
Fluorite | Level 6

Hi All, 

 

I was building a logistic regression, and part of the Odds Ratio result is shown below.. 

 

   Odds Ratio Estimates
 
                                                                                  Point
Effect                                                                         Estimate
 
var_Finance_Insurance          0 vs NoCC                                          1.729
var_Finance_Insurance          1 vs NoCC                                          2.334
var_Gender                     F vs M                                             1.128
var_Health_GeneralHealth       0 vs NoCC                                          0.586
var_Health_GeneralHealth       1 vs NoCC                                           .
var_Leisure_BookWorm           0 vs NoCC                                          1.304
var_Leisure_BookWorm           1 vs NoCC                                           .

 

I am just wondering for var_Health_GeneralHealth (1 vs NoCC) and var_Leisure_Bookworm (1 vs NoCC), why does it have a Odd ratio of "."? 

 

Is it because it has a same % as var_Finance_insurance for the NoCC? Below are my distribution for var_Health_General, var_Leisure_Bookworm and var_Finance_insurance. 

 

var_Leisure_BookWormCount(*)Sum(TARGET)%
1416310680.25654576
02545162390.245137716
NoCC1614229930.185416925
    
    
var_Finance_InsuranceCount(*)Sum(TARGET)%
1991028720.289808274
01970444350.225081202
NoCC1614229930.185416925
    
var_Health_GeneralHealthCount(*)Sum(TARGET)%
1479215020.313439065
02482258050.23386512
NoCC1614229930.185416925

 

3 REPLIES 3
WendyCzika
SAS Employee

If you are using GLM effect coding of your class inputs, then you will always have 1 level that has a missing estimate since the estimates are calculated in reference to one of the levels (the reference level) and the parameterization is singular.  If you are using the Regression node in SAS Enterprise Miner, you can change the Input Coding property to Deviation to get estimates for all levels compared to the average effect of all levels.

okla
Fluorite | Level 6

Hi,

 

The result i shown was actually based on "Deviation" setting. I tried GLM as well, same thing happen. I am using EM12.1

 

EM.png

WendyCzika
SAS Employee

Ahhh, ok.  Then as you first said, I would think there is another input or coded effect perfectly correlated with the coded effect for the levels of those inputs.

SAS Innovate 2025: Save the Date

 SAS Innovate 2025 is scheduled for May 6-9 in Orlando, FL. Sign up to be first to learn about the agenda and registration!

Save the date!

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
  • 3 replies
  • 2868 views
  • 0 likes
  • 2 in conversation