topic Re: odds ratios table for multiple variables in SAS Procedures

odds ratios table for multiple variables

billroy3 — Thu, 30 Jul 2015 18:31:42 GMT

Does anyone know any easy way to create an odds ratio table, analogous to a correlation table for multiple (binary) variables so that Xij would be the odds ratio for variables i and j?

William Roy

Professor of Sociology

UCLA

Re: odds ratios table for multiple variables

Ksharp — Fri, 31 Jul 2015 14:56:19 GMT

Check proc freq,

OR you want SAS/IML code ?

Post it at IML forum, Rick might give you something you need.

Re: odds ratios table for multiple variables

billroy3 — Fri, 31 Jul 2015 16:37:03 GMT

Thank you Xia. Proc freq creates one dataset per pair of variables. They can concatenated, but I would hoping for a matrix like a correlation matrix. I can do it in IML, but was hoping someone would have designed a macro to make it simple.

Bill Roy

Re: odds ratios table for multiple variables

Ksharp — Sat, 01 Aug 2015 10:09:19 GMT

Why would you need a data step macro ? I think IML is more simple and succinct than it . Don't you think so ?

Re: odds ratios table for multiple variables

billroy3 — Sat, 01 Aug 2015 16:12:50 GMT

Yes, I do. Not finding an existing macro, I've designed one myself and am working to refine it.

Re: odds ratios table for multiple variables

Ksharp — Sun, 02 Aug 2015 03:48:15 GMT

What does your data look like ? Post some sample data . Let me see how it work.

Re: odds ratios table for multiple variables

billroy3 — Mon, 03 Aug 2015 15:24:11 GMT

Xia,

I have written my own macro and no longer need help. Thank you for your offer.