Hi:
There are other ways to invoke a stored process. The technologies you should look at are the SAS Stored Process Web Application or SAS BI Web Services for Java or SAS BI Web Services for .NET -- any of these would allow you to write your own custom front end to invoke a stored process.
SAS Stored Process Web Application: This is a Java Web application that executes stored
processes and returns results to a Web browser. The SAS Stored Process Web Application
is included with the SAS Web Infrastructure Kit, a component of SAS Integration
Technologies as described here:
http://support.sas.com/rnd/itech/doc9/dev_guide/stprocess/stpwebapp.html#defaultform
SAS BI WEB Services: There is a .NET client and a Java client, as described here:
http://support.sas.com/rnd/itech/doc9/dev_guide/websrvcs/index.html
http://support.sas.com/rnd/itech/doc9/dev_guide/websrvcs/using.html
I have only had experience using the SAS Stored Process Web Application, when I use that, I can execute a stored process via URL using the following URL as a model. Anchor tag:
<a target="new" href="http://localhost:9090/SASStoredProcess/do?
_program=/STP_Orion/Extra/testSPWA">Test this stored process</a>
If I had a different host or port number then the URL might be different:
<a target="new" href="http://www.wombat.com:5450/somedir/SASStoredProcess/do?
_program=/STP_Orion/Extra/testSPWA">Test this stored process</a>
This assumes that I have a Stored Process Repository called
STP_Orion, with a sub folder of
Extra and inside that location, I have a stored process with the name
testSPWA. The metadata for the stored process points to the location of the .SAS file that should be executed by the Stored Process Web Application. And all my services and Tomcat need to be started before I would try to use the URL.
If you go out to the Integration Technologies Web site, you will find that the syntax for using .NET or Java is different. So, first, you have to decide which method for developing a custom application you're going to use. Then you'll have to look at the sample programs and read the documentation for the method you finally decide on.
cynthia