topic How do I get a drop down menu to run a sas script? in ODS and Base Reporting

How do I get a drop down menu to run a sas script?

Yennie — Wed, 27 Jan 2010 05:48:12 GMT

At the moment, I have a html page that consist of three fields. so the user has to select the date and the type of data they like to view then click "Submit". Once it's submit, this excute a sas script in my system and allow that to be run then output the results in another html window.

Just wondering if anyone knows how to do this?

much appreciated!
Yennie

Re: How do I get a drop down menu to run a sas script?

sbb — Wed, 27 Jan 2010 14:44:22 GMT

You mentioned: "...the user has to select..." -- would that interaction be performed on a different computer system, not yours where SAS is installed/executed? I believe you need to have a SAS server installed with public/authorized access granted.

Scott Barry
SBBWorks, Inc.

Re: How do I get a drop down menu to run a sas script?

sbb — Wed, 27 Jan 2010 15:53:37 GMT

From the SAS support website, here are conference papers (dated but still relevant) on the topic. Also, some current SAS Stored Process DOC, as well.

Scott Barry
SBBWorks, Inc.

Let SAS® Build Your Dynamic Web Site from the Data!
Jennifer Sinodis, Bank One, Phoenix, AZ
Mark Moran, Bank One, Phoenix, AZ
http://www2.sas.com/proceedings/sugi27/p173-27.pdf

A Dynamic Example of Delivering Patient Management Identification
Opportunities Using SAS/IntrNet®
Richard W. Kobylinski, Aetna® Health Analytics, Blue Bell, PA
http://www2.sas.com/proceedings/forum2007/017-2007.pdf

SAS Stored Processes: Developer's Guide, Example
http://support.sas.com/documentation/cdl/en/stpug/61271/HTML/default/a003172097.htm

Re: How do I get a drop down menu to run a sas script?

Cynthia_sas — Wed, 27 Jan 2010 17:48:59 GMT

Hi:
You have some good links from Scott. This sounds like the type of application that can be built using SAS/IntrNet, using HTML forms and htmSQL or with the Enterprise BI server and the Enterprise Intelligence Platform with SAS Stored Processes.

For the SAS/IntrNet approach, you would need an HTML form as the front end (to show them their selection choices. For the Stored Process approach, user-supplied input parameters would take the place of the HTML "front end". Both SAS/IntrNet and the Enterprise Intelligence Platform are suites of products that work in a client/server environment.

You can also get some of this functionality using Tasks in Enterprise Guide projects through the use of the Parameter Manager, to collect and pass user selections to the saved EG project.

cynthia