David's point, as usual, is right on.
I would ask why not invest the time getting a comparable graph out of
SAS/Graph. I know it can be a chore at times to get SAS/Graph to produce
nice graphics, but it can be done.
And if you use SAS/Graph, ODS will take care of titles, footnotes,
rendeering the image - all to your user's browser.
Just another thought.
From: SAS(r) Discussion [mailto:SAS-L@LISTSERV.UGA.EDU] On Behalf Of David
Sent: Wednesday, February 16, 2005 4:19 PM
Subject: Re: viewing Excel output on internet--SAS inter/net
nevin <nevinkrishna@HOTMAIL.COM> replied:
> I apologize for the confusion, i think i confused myself disregard the
> entire part about the user altering titles etc..
> Basically what i am trying to get is an excel chart to be
> to a users browser..
> What i have is an html form which has two variables, year (in a
> down box) and disease (in a drop down box) when a user selects a year
> and a disease and clicks a submit button, a sas program is invoked
> which populates a two columns in an excel file (saved on the
> server),with the number of cases of a disease by month for the year
> selected. This excel template on the server has the graph already
> created, so everytime the user submits a different year and disease
> request, the graph changes accordingly..This all works fine when i
> it, but i can not figure out how to have the user view the graph on
> their browser..
> i hope this is a bit clearer..
Yes, this is a bit clearer. Thanks. But I still don't see why you want to
push an entire Excel spreadsheet down to a user's platform. All you need to
do is set up a system to display a simple graph, which is very different.
In fact, you can simplify this even further, by creating all the graphs
ahead of time, and then, given a particular year-disease pair, pull up the
appropriate graph in real time. Do you really need more than this?
David Cassell, CSC
Senior computing specialist