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

Hi,

I ran a logistic regression on my dataset and got the following error:

ERROR: All observations have the same response.  No statistics are computed.

Could it be so because I am modeling rare events? (~175 events out of 200,000+ observations)

Thanks for any advice

1 ACCEPTED SOLUTION

Accepted Solutions
bobderr
SAS Employee

This message should only be printed if FLAG takes a single value.  Do your predictors have any missing values?  If so, those observations are dropped from the model fitting, and if all observations with FLAG=1 are removed the message is displayed.

View solution in original post

9 REPLIES 9
Rick_SAS
SAS Super FREQ

Yes, but more specifically I'd guess that there is some classification variable for which all the Y=1 belong to a single category.  For example, if you are using CLASS GENDER, maybe all of the Y=1 values are male.

Try using PROC FREQ to cross tabulate Y with your classification varialbles.  You might see an empty cell. That would indicate that you cannot use that classification variable as an explanatory variable.

lavernal
Calcite | Level 5

Hi Rick,

Thanks for the answer. I did not use any classification but instead, used proc logistic on my whole dataset. So there should not be a situation where there are all Y=1 or Y=0. That's also why I was confused that I got such an error.

Rick_SAS
SAS Super FREQ

Do you have a WHERE clause or other DATA= option that is filtering data? Or a format that coalesces values of an explanatory variable?

What does your MODEL statement look like?

lavernal
Calcite | Level 5

Hi Rick,

My model is really simple. My code is:

proc sort data=fun;

by id year quarter;

run;

proc logistic data=fun descending;

model flag= var1 var2 var3 var4 var5 var6 var7 var8 var9 var10 var11 var12;

output out=propensity_scores pred=prob_flag;

run;

I'm not sure where any filtering or coalescing may have occurred.

Rick_SAS
SAS Super FREQ

Hmm, interesting. And what do you get from running the following?

proc freq data=fun; tables flag; run;

lavernal
Calcite | Level 5

Hi Rick,

I get the following output:

                                                                  Cumulative    Cumulative

                 Flag      Frequency     Percent     Frequency      Percent

                 ƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒ

                       0      252784       99.93        252784        99.93

                       1         174          0.07        252958       100.00

Rick_SAS
SAS Super FREQ

My guess is that there is a linear combination of your continuous variables that perfectly explain your response.  For example, if you are modeling "had a heart attack," it might be that "blood pressure," "cholesterol," and "stress level" do not individually predict the response, but when you include all of those variables in the model you discover that all of the heart attacks in the data can be predicted by the linear combination of those factors.

bobderr
SAS Employee

This message should only be printed if FLAG takes a single value.  Do your predictors have any missing values?  If so, those observations are dropped from the model fitting, and if all observations with FLAG=1 are removed the message is displayed.

lavernal
Calcite | Level 5

Hi Bobderr,

Thanks for your advice. It seems that this is indeed the reason. When I removed some of the independent variables, the regression worked!

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
  • 9 replies
  • 17899 views
  • 8 likes
  • 3 in conversation