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
- /
- Data Mining
- /
- Exporting odds ratio in EM

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

06-24-2016 09:23 AM - edited 06-24-2016 09:45 AM

I just started working with an EM evalulation and have tried logistic regression models. I was able to find how to export the coefficient values, but am unable to figure out how to export the odds ratios into a csv/excel file. How can I accomplish this other than reading the text log output of the model?

Edit:

Trying to get a similar output as I can in Enterprise Guide

Accepted Solutions

Solution

06-27-2016
06:08 PM

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

06-24-2016 10:17 AM

Hi.

Since you already have coefficients in a dataset, you can use the EXP() function in SAS to transform them to odds ratios, i.e.,

oddsratio=exp(coefficient);

Similar with the upper and lower confidence for the coefficients to compute the CI for the odds ratio.

Hope this helps.

Ray

All Replies

Solution

06-27-2016
06:08 PM

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

06-24-2016 10:17 AM

Hi.

Since you already have coefficients in a dataset, you can use the EXP() function in SAS to transform them to odds ratios, i.e.,

oddsratio=exp(coefficient);

Similar with the upper and lower confidence for the coefficients to compute the CI for the odds ratio.

Hope this helps.

Ray

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

06-24-2016 10:21 AM

..or transform the coefficients in Excel, which appears to have an exp function:

https://support.office.com/en-us/article/EXP-function-c578f034-2c45-4c37-bc8c-329660a63abe

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

06-27-2016 06:08 PM

Thank you for your answer, and sorry for my delay!

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

06-28-2016 10:47 AM

Glad it helped.

Ray