topic How to calculate or get odds ratio (OD) and relative risk (RR) for overall response table? in SAS Programming

How to calculate or get odds ratio (OD) and relative risk (RR) for overall response table?

yogita_patel — Fri, 03 Jan 2025 22:45:05 GMT

Hello,

How to calculate or get odds ratio and relative risk for Overall response table. I have 2 treatment group.

I tried with proc freq,

proc freq data=workorr;
by trt01pn mainord;
table ord / chisq relrisk;
weight count;
output chisq relrisk out=ratio;
run;

/****OR***/
ods listing close;
ods output cmh = relrto;

proc freq data=orr2 ;
by mainord ;
tables stratan*trt01pn*ord / cmh relrisk;
run;

But I am not getting in output dataset. I am only getting chi sq. value for first code and p value for second code.

I got risk diff. (RD) with below code.

ods trace on;
/*95% CI*/
proc freq data=workorr;
by trt01pn mainord ;
table ord / binomial ;
exact binomial;
weight count / zero ; /*add this for zero CI's*/
output binomial out=orr_ ;
RUN;
ods trace off;

please let me know if I am missing something or doing something wrong.

Thanks you.

Re: How to calculate or get odds ratio (OD) and relative risk (RR) for overall response table?

quickbluefish — Sat, 04 Jan 2025 01:52:04 GMT

Not sure exactly which ones, but I would recommend you google "PROC FREQ ODS TABLE NAMES" and look there for relrisk and OR-related things.

Re: How to calculate or get odds ratio (OD) and relative risk (RR) for overall response table?

Ksharp — Sat, 04 Jan 2025 09:07:35 GMT

OR and RR are all for 2x2 contingency table, so you need 2 category variables with 2 levels to calculated them.
https://support.sas.com/kb/23/003.html

For high dimension contingency table: