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

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

eg.jpg

1 ACCEPTED SOLUTION

Accepted Solutions
rayIII
SAS Employee

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

View solution in original post

4 REPLIES 4
rayIII
SAS Employee

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

rayIII
SAS Employee

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

 

 

 

jbencina
Calcite | Level 5

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

rayIII
SAS Employee

Glad it helped.

 

Ray

sas-innovate-2024.png

Available on demand!

Missed SAS Innovate Las Vegas? Watch all the action for free! View the keynotes, general sessions and 22 breakouts on demand.

 

Register now!

How to choose a machine learning algorithm

Use this tutorial as a handy guide to weigh the pros and cons of these commonly used machine learning algorithms.

Find more tutorials on the SAS Users YouTube channel.

Discussion stats
  • 4 replies
  • 1451 views
  • 0 likes
  • 2 in conversation