Date:         Tue, 18 Oct 2011 09:06:45 -0400
Reply-To:     Rick Wicklin <Rick.Wicklin@SAS.COM>
Sender:       "SAS(r) Discussion" <SAS-L@LISTSERV.UGA.EDU>
From:         Rick Wicklin <Rick.Wicklin@SAS.COM>
Subject:      Re: FUNNel plots +sas annotate help

> From: sourav ghosh
> Sent: Monday, October 17, 2011 2:47 PM
> To: Rick Wicklin
> Subject: Re: FUNNel plots +sas annotate help
>
> I need just a funnel chart shape plot.,since  other value will
> be just scatter plot value . But I am not sure how to create the
> funnel plot. If I have to create a annotate dataset, then
> How to create it for funnel plot. Also I don't have license for
> plot IML. But if you check the pdf then I think they are not
> creating funnel chart from data value.Data value are for scatter
> plot. they are just creating funnel type plot with some fixed
> data, then adjusting on y & x axis range, So I am not sure
> how to do it.
>
> Thanks
> Sourav

Sourav,
Please respond to the list, not to me personally.  As Nat Wooding pointed
out, the data you sent to SAS-L is not in the correct form for plotting as
a funnel plot. From your latest message, it sounds like your problem is
how to COMPUTE the upper and lower limits. Is that correct?

The reference for computing the upper and lower limits for a funnel plot
is Spiegelhalter 2005: http://bit.ly/oj6O2p
By the names of your variables, I'm guessing you are trying to compute
something related to ratios of boys to girls in various geographic
regions. Appendix A, section A.1, of Spiegelhalter 2005 contains the
formulas that are used for the upper and lower limits for ratios.

If you post the DATA step and PROC code that you used to compute the
upper/lower limits from the raw data, the list can see what formulas you
are using, and suggest alternatives.  Since you don't have SAS/IML, I'll
let the Base SAS experts assist you.

Good luck,
Rick