turn on suggestions

Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.

Showing results for

Find a Community

- Home
- /
- SAS Programming
- /
- General Programming
- /
- Funnel plot for standardized rate

Topic Options

- Subscribe to RSS Feed
- Mark Topic as New
- Mark Topic as Read
- Float this Topic for Current User
- Bookmark
- Subscribe
- Printer Friendly Page

- Mark as New
- Bookmark
- Subscribe
- Subscribe to RSS Feed
- Permalink
- Email to a Friend
- Report Inappropriate Content

04-28-2016 12:02 PM

Hy,

I raise an unresolved issue posted in 2013.

I am wondering if anyone has had experience working with indirectly standardized rates.

Standardized rates is the product of the target crude rate and the ratio of observed to expected values from the relevant regression model.

In short, I try to compute the control limits by using the formulas in Appendix A.2.1.in Spiegelhalter's 2005 paper on funnel plots.

I'm working on SAS 9.3.

Thanks,

IE

- Mark as New
- Bookmark
- Subscribe
- Subscribe to RSS Feed
- Permalink
- Email to a Friend
- Report Inappropriate Content

Posted in reply to Isevr

05-01-2016 12:58 PM

Hi:

Look at these 2 blog posts. One of them mentions the Spiegelhalter paper:

http://blogs.sas.com/content/iml/2011/04/15/funnel-plots-an-alternative-to-ranking.html

http://blogs.sas.com/content/iml/2011/11/23/funnel-plots-for-proportions.html

cynthia

Look at these 2 blog posts. One of them mentions the Spiegelhalter paper:

http://blogs.sas.com/content/iml/2011/04/15/funnel-plots-an-alternative-to-ranking.html

http://blogs.sas.com/content/iml/2011/11/23/funnel-plots-for-proportions.html

cynthia

- Mark as New
- Bookmark
- Subscribe
- Subscribe to RSS Feed
- Permalink
- Email to a Friend
- Report Inappropriate Content

Posted in reply to Cynthia_sas

05-02-2016 03:14 AM

Thank you for answering.

These papers are for binomial and normal variables, I'm looking for the application for poisson variable.

Isabelle

- Mark as New
- Bookmark
- Subscribe
- Subscribe to RSS Feed
- Permalink
- Email to a Friend
- Report Inappropriate Content

Posted in reply to Isevr

05-03-2016 10:31 AM

Yes, but Spieghalter show in Appendix A.2 how to compute the limits for the Poisson case. The second blog post uses the formulas from Appendix A.1, but the idea is the same. The important programming detail is that you can use the QUANTILE function to invert the cumulative Poisson distribution (F^{-1} in the paper). For the interpolation, mimic what the blog post does when it interpolates the binomial proportions.

- Mark as New
- Bookmark
- Subscribe
- Subscribe to RSS Feed
- Permalink
- Email to a Friend
- Report Inappropriate Content

Posted in reply to Rick_SAS

05-03-2016 10:55 AM

I try to.It seems to work for smr (target theta=1) but for standardized ratio with target not equal to 1, it is not so simple.

Thank you anyway.

- Mark as New
- Bookmark
- Subscribe
- Subscribe to RSS Feed
- Permalink
- Email to a Friend
- Report Inappropriate Content

Posted in reply to Isevr

10-19-2017 09:06 AM

Hi Isevr,

I am having the same problem as you. Did you manage to write a sytnax for the intervals for SMR using the poisson distribution? Would you mind sharing it? That would be so helpful!

Thanks a lot!