The SAS Output Delivery System and reporting techniques

create report by clicking a bottom on a website

Reply
Occasional Contributor
Posts: 16

create report by clicking a bottom on a website

Hi. I don't know if this is possible, but I am trying to see if following is at all possible. I have SAS program that creates an html / tabulate report. It is great. But I would like to see if I can possibly set up a bottom on a web site that by clicking it will activate this program & run it & then post it on a web site. Currently I run report manually on PC SAS, but would like to automize it so it can be run without "human" clicking /starting a PC SAS program. Is there a way to do it?
SAS Super FREQ
Posts: 8,743

Re: create report by clicking a bottom on a website

Hi:
You are describing the kind of processing done by the SAS/IntrNet product (where a user can click on a URL and dynamically execute a SAS program) or by the SAS Enterprise Intelligence Platform, where a stored process (a SAS program) can be executed on a server machine by clicking on a URL.

There are other ways to submit batch programs -- using a .BAT file or a .CMD file or running them from a script -- but no matter how you do it, somewhere, on some SAS server, the SAS.EXE program must start up and run. Using a batch program allows you to start up and run SAS during non-peak hours; using other, more advanced techniques allow you to execute a SAS program dynamically or "on demand". Either way, SAS is starting up, the question is how, and when.

If it would be OK for your web page to point to an HTML file that was created nightly, you could create a batch job to run overnight that would update the HTML report file. Then when your users clicked on the web site link, they would call up the most recently created HTML file. In that instance, SAS would not need to be active, because the users would just be accessing a file that was created for them in a nightly batch run.

You might look at the SAS Companion documentation for your operating system to see how to do batch submissions on your platform. Or you could look at some of these papers which describe other users' approaches to "web enablement" -- both with and without SAS/IntrNet or the Enterprise Intelligence Platform:

http://www2.sas.com/proceedings/sugi28/127-28.pdf
http://support.sas.com/resources/papers/proceedings09/031-2009.pdf
http://www2.sas.com/proceedings/forum2008/012-2008.pdf

Web enablement is the general term for what you're asking about. Web enablement can be as simple as building a directory of HTML files created by SAS and keeping them on a web server machine where they are accessible or as complex as using components like SAS/IntrNet or the SAS Enterprise Intelligence Platform to execute programs "on demand".

cynthia
Ask a Question
Discussion stats
  • 1 reply
  • 120 views
  • 0 likes
  • 2 in conversation