turn on suggestions

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

Showing results for

Find a Community

- Home
- /
- Analytics
- /
- Stat Procs
- /
- Re: Dealing with 0 cells in logistic regression

Topic Options

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

- Mark as New
- Bookmark
- Subscribe
- RSS Feed
- Permalink
- Email to a Friend
- Report Inappropriate Content

12-07-2017 04:48 PM

I am running a logistic prediction models where one of my categorical (3 categories) independent variables has a 0 cell one of the outcome groups. Is there a way I can deal with this in SAS without having to collapse the categories, since it would not make clinical sense to do so in this situation?

Accepted Solutions

Solution

12-14-2017
04:15 PM

- Mark as New
- Bookmark
- Subscribe
- RSS Feed
- Permalink
- Email to a Friend
- Report Inappropriate Content

Posted in reply to jo_rod

12-08-2017 08:39 AM

You could try fitting an exact logistic regression via the EXACT statement in LOGISTIC

All Replies

- Mark as New
- Bookmark
- Subscribe
- RSS Feed
- Permalink
- Email to a Friend
- Report Inappropriate Content

Posted in reply to Melk

12-07-2017 04:58 PM

Could you give more detail as to why you can't collapse the groups? And when you say 0 cells, do you mean there were 0 observations for that specific category in the outcome, or it had 0 observations for some of your covariates?

- Mark as New
- Bookmark
- Subscribe
- RSS Feed
- Permalink
- Email to a Friend
- Report Inappropriate Content

Posted in reply to jo_rod

12-07-2017 05:02 PM - edited 12-07-2017 05:03 PM

One of the categories of a predictor I would like to enter into the prediction model has 0 observations for 1 category of the binary outcome. Here are the number for that variable in my data:

**Mortality**

** 0 1**

**X 1 **64 42

** 2 **4 13

** 3 ** 4 0

I do not want to collapse 2 and 3 because it does not make any sense clinically to do so - they are separately meaningful categories of X.

Highlighted
## Re: Dealing with 0 cells in logistic regression

Options

- Mark as New
- Bookmark
- Subscribe
- RSS Feed
- Permalink
- Email to a Friend
- Report Inappropriate Content

Posted in reply to Melk

12-07-2017 05:30 PM

My suggestion would be to drop that category. You can't infer anything from it if you have no response for a category. As well, you're likely to run into some type of problem like quasi-seperation for that category. It maybe something you're really interested in, but it may be best to look only at the other two categories, and then report on the third having too much missing data.

Though, if you really want to keep it and have the time, you could look into multiple imputation. I don't have much experience with that, so I can't give too much input on whether it's even feasible for this situation.

Solution

12-14-2017
04:15 PM

- Mark as New
- Bookmark
- Subscribe
- RSS Feed
- Permalink
- Email to a Friend
- Report Inappropriate Content

Posted in reply to jo_rod

12-08-2017 08:39 AM

You could try fitting an exact logistic regression via the EXACT statement in LOGISTIC

- Mark as New
- Bookmark
- Subscribe
- RSS Feed
- Permalink
- Email to a Friend
- Report Inappropriate Content

Posted in reply to jo_rod

12-10-2017 05:34 PM

But couldnt the fact that I have no responses for a particular category in itself be informative?

- Mark as New
- Bookmark
- Subscribe
- RSS Feed
- Permalink
- Email to a Friend
- Report Inappropriate Content

Posted in reply to Melk

12-11-2017 01:45 PM

Depending on your research question, sometimes it won't be informative and you would need to drop the category if you can't collapse it with another group. So you could go with what SAS_Rob mentioned and do an exact logistic regression.