topic Re: Exporting odds ratio in EM in SAS Data Science

Exporting odds ratio in EM

jbencina — Fri, 24 Jun 2016 13:45:17 GMT

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

Re: Exporting odds ratio in EM

rayIII — Fri, 24 Jun 2016 14:17:36 GMT

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

Re: Exporting odds ratio in EM

rayIII — Fri, 24 Jun 2016 14:21:35 GMT

..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

Re: Exporting odds ratio in EM

jbencina — Mon, 27 Jun 2016 22:08:35 GMT

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

Re: Exporting odds ratio in EM

rayIII — Tue, 28 Jun 2016 14:47:24 GMT

Glad it helped.

Ray