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
- /
- Multinomial Regression

Topic Options

- Subscribe to 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
- Subscribe to RSS Feed
- Highlight
- Email to a Friend
- Report Inappropriate Content

04-01-2012 03:04 PM

I have large dataset with more than 50,000 rows. My outcome variable is a nominal variable with 4 outcomes, of which 3 are ordinal and the 4th is independent of the other 3. My predictors list contains more than 100 variables, of which some are categorical and some are continuous. The categorical predictors are not ordinal.

I researched PROC GENMOD which allows to predict multinomial regression but doesnt have variable select method. I also looked up PROC Logistic which can predict oridnal outcome variable and has variable selection option.

I would like to know which procedure to use and with what options. Please help! Thanks.

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

04-01-2012 03:17 PM

"*My outcome variable is a nominal variable with 4 outcomes, of which 3 are ordinal and the 4th is independent of the other 3*." - Please explain further.

PG

PG

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

04-01-2012 03:28 PM

PG,

The outcome variable is a product type of which 3 products are is ordinal in terms of risk ratings. The 4th is a different type of product. For this discussion we can consider two scenarios.

1. All are different

2. All are ordinal

Depending on both solutions, I can then furture analyze and customize the procedure to my needs. Hope this helps.

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

04-01-2012 03:50 PM

You mean something like possible outcomes are ( 1, 2, 3, A )?

Interesting. This seems like the type of analysis that marketing experts do.

Hope one can help you.

CART modelling (a data mining tool) would seem like a good place to start.

PG

PG

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

04-02-2012 09:11 AM

Outcomes that are {1,2,3,A}? That is a new concept for me.

Someone who actually understands your model (not me!) might have a better way to do it, but to get the ball rolling, would it be possible to run this model in two stages?

1) Subset the data to WHERE(Y^=A). For this subset, use an ordinal regression model.

2) For the full data, create a new indicator variable isA = (y=A). Build a logistic regression for this model.

For scoring new data, you would use the logistic model to predict whether the data is 'A' or 'Not A.' If it is 'Not A', then use the ordinal model to predict whether the response is 1,2, or 3.

I am interested in hearing from statistical gurus like PG whether it has any merit or whether this approach should be avoided. As I said, I basically "made it up" on the spot.

Rick

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

04-02-2012 09:45 AM

Hi Rick,

Thanks for your reply.

"

1) Subset the data to WHERE(Y^=A). For this subset, use an ordinal regression model.

"

Based on my dataset which procedure do you recommend and with what options? I want to have variable selection as well.

Thanks.

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

04-02-2012 09:55 AM

As far as I know, PROC LOGISTIC is the only procedure that does both. See the doc for an example of ordinal regression: http://support.sas.com/documentation/cdl/en/statug/63962/HTML/default/viewer.htm#statug_logistic_sec...