topic Re: Funnel plot for rates in SAS Programming

Funnel plot for rates

sarahcjj — Sun, 17 Mar 2024 03:57:11 GMT

Has anyone had success adapting Rick Wicklin's funnel plot for proportions code https://blogs.sas.com/content/iml/2011/11/23/funnel-plots-for-proportions.html for rates that can be >1?

Briefly, I'd like to identify "high-intensity" antibiotic prescribers. My y-axis would be prescriber's antibiotic prescriptions / number of patient visits (which can be >1) in 1 year and my axis-would be number of patient visits in 1 year.

Thanks in advance for any help.

Re: Funnel plot for rates

Rick_SAS — Sun, 17 Mar 2024 11:16:19 GMT

Yes. See

Both articles include links to the SAS programs that generate the funnel plots.

Re: Funnel plot for rates

sarahcjj — Mon, 18 Mar 2024 02:18:03 GMT

Thank you so much. I read in one of the comments that the funnel plot code is for binomial proportions between 0 and 1. I have observations where the number of events is greater than the number of trials. Would the code still be appropriate for these data?

Re: Funnel plot for rates

Rick_SAS — Mon, 18 Mar 2024 10:42:29 GMT

You can try it. The upper/lower curves on the funnel plot are determined by the average proportion, which is the total number of events divided by the total number of trials. If this value is less than 1, you can compute and plot the curves. The actual data values are just displayed in the scatter plot.

I encourage you to think about what statistical model might be appropriate for your data. If you have rates that are greater than 1 or negative, then there are probably more appropriate models.

Re: Funnel plot for rates

sarahcjj — Tue, 19 Mar 2024 02:47:18 GMT

Thanks so much for your help