Date:         Wed, 28 Sep 2005 15:45:52 -0400
Reply-To:     "Michael S. Zdeb" <msz03@health.state.ny.us>
Sender:       "SAS(r) Discussion" <SAS-L@LISTSERV.UGA.EDU>
Comments:     To: Sierra Information Services <sfbay0001@AOL.COM>
From:         Mike Zdeb <msz03@HEALTH.STATE.NY.US>
Subject:      Re: ODS/HTML/DRILL DOWN?
In-Reply-To:  <1127933382.444759.222630@o13g2000cwo.googlegroups.com>
Content-type: text/plain; charset=US-ASCII

Hi.   Well, I didn't use ODS HTML, but I did use SAS to do all the table,
graphs, maps that are on...

http://www.health.state.ny.us/nysdoh/chac/chds.htm

It does fit your 'government report' requirement and the maps are done
using ODS, combining the bar chart and map via the STARTPAGE=NEVER option.
Give it a try...

Click on an INDICATOR (e.g. CHRONIC CONDITIONS), then click on a (T+TR)
(e.g. next to DIABETES).  Then click on any county name to see a 10-year
trend.  You can also click on the (M) to see a map, but there's no
drill-down after that.

I did all the SAS code before there was an ODS, plus the health department
web rules are pretty strict and I think that it is still easier to conform
to the rules by doing the coding in a data step rather than with ODS
(though I'd be happy to be proven wrong).

PS  The beauty of having all this done with SAS is that when it's updated,
it's more or less a task of just changing the data.  There are alsa lot of
data-driven decisions made by the SAS code (for example, add a footnote to
a map/or not based on the number of cases of a particular disease or number
of deaths).

Mike Zdeb
U@Albany School of Public Health
1 University Drive
Rensselaer, NY   12144-3456
(P)518-402-6479
(F)630-604-1475




             Sierra
             Information
             Services                                                   To
             <sfbay0001@AOL.CO         SAS-L@LISTSERV.UGA.EDU
             M>                                                         cc
             Sent by: "SAS(r)
             Discussion"                                           Subject
             <SAS-L@LISTSERV.U         ODS/HTML/DRILL DOWN?
             GA.EDU>


             09/28/2005 02:49
             PM


             Please respond to
                  Sierra
                Information
                 Services
             <sfbay0001@AOL.CO
                    M>






Hi...does anyone on the list know of a public web site that has
examples where ODS has been used to generate drill-down reports
accessible to the public? I am hoping there's a government agency web
site "out there" that I might access via the web that shows these
capabilites.

Thanks in advance...

  Andrew