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

I need help determining the correct way to compare changes in rates of two medical procedures between two groups before and after an intervention. So the data look something like this:

                         Before                    After

                   Proc1    Proc2        Proc1    Proc2

Group #1     21609    51815      4793       7191

Group #2     11935    67953      3808       10829

 

The question I want to answer is this: Is there a difference between the two groups in the change of the ratio of Proc1 to Proc2 before and after the intervention?

 

I was thinking of something like this (code adapted from an on-line example):

 

data YesNo;

length Group $ 11 ;

input Group $ Period $ Proc1 Total;

Response="Proc1"; Count=Proc1 ; output;

Response="Proc2"; Count=Total-Proc1 ; output;

datalines;

Group1 Before 21069 72884

Group1 After 4793 11984

Group2 Before 11935 79528

Group2 After 3808 14637

 

;

proc print noobs;

var Group Period Response Count;

run;

ods graphics on;

proc freq data =YesNo order=data;

weight Count;

tables Period*Group*response / relrisk cmh chisq plots=all;

exact eqor;

run;

ods graphics off;

 

Is this the correct approach? I'm not sure how to interpret the output. Any help would be greatly appreciated!

 

Brian

1 ACCEPTED SOLUTION

Accepted Solutions
drb4511
Obsidian | Level 7
The Breslow-Day (from the CMH option) tells you that the rate ratios for your strata are the same (p>.05) or different (p<.05). It is only comparing the rate ratios (or odds ratios) for group*response for each level of period.

If you are trying to see within group differences (ex: is there a significant change in the rate for group 1), you'd need to do something different, maybe even just plotting the rates with a linear reg.

View solution in original post

3 REPLIES 3
BTAinRVA
Quartz | Level 8

Does anyone know what eaxctly the Breslow-Day statistic is telling me when you run the code I posted? Is that just an overall comparison of the two groups or does it compare the before/after rates for each group?

 

Thanks in advance!

drb4511
Obsidian | Level 7
The Breslow-Day (from the CMH option) tells you that the rate ratios for your strata are the same (p>.05) or different (p<.05). It is only comparing the rate ratios (or odds ratios) for group*response for each level of period.

If you are trying to see within group differences (ex: is there a significant change in the rate for group 1), you'd need to do something different, maybe even just plotting the rates with a linear reg.
BTAinRVA
Quartz | Level 8

drb4511

 

Thanks for the reply. I think that answers my question.

 

Brian

sas-innovate-2024.png

Don't miss out on SAS Innovate - Register now for the FREE Livestream!

Can't make it to Vegas? No problem! Watch our general sessions LIVE or on-demand starting April 17th. Hear from SAS execs, best-selling author Adam Grant, Hot Ones host Sean Evans, top tech journalist Kara Swisher, AI expert Cassie Kozyrkov, and the mind-blowing dance crew iLuminate! Plus, get access to over 20 breakout sessions.

 

Register now!

New Learning Events in April

 

Join us for two new fee-based courses: Administrative Healthcare Data and SAS via Live Web Monday-Thursday, April 24-27 from 1:00 to 4:30 PM ET each day. And Administrative Healthcare Data and SAS: Hands-On Programming Workshop via Live Web on Friday, April 28 from 9:00 AM to 5:00 PM ET.

LEARN MORE

Discussion stats
  • 3 replies
  • 2368 views
  • 0 likes
  • 2 in conversation