Date:         Thu, 9 Aug 2007 19:10:34 -0400
Reply-To:     Don Henderson <donaldjhenderson@HOTMAIL.COM>
Sender:       "SAS(r) Discussion" <SAS-L@LISTSERV.UGA.EDU>
Comments:     RFC822 error: <W> MESSAGE-ID field duplicated. Last occurrence
              was retained.
From:         Don Henderson <donaldjhenderson@HOTMAIL.COM>
Subject:      Re: EG/IT and stored processes
In-Reply-To:  <BD4DF887B662FD46A3786A2E6547925BD3F634@GP2K0084V3.GEICO.corp.net>
Content-Type: text/plain; charset="us-ascii"

Martin,

This is a limitation of the prompting model for stored processes in 9.1.3. I
am pretty sure it has been addressed in 9.2 (seen some examples of it) if
you don't need to customize the look and feel of the UI that does the
prompting.

What options you have in 9.1.3 depend on what the clients are. For example,
if the Stored Processes will be called via the web, you can write custom JSP
pages for the stored processes and have SAS invoke them for automagically
whenever a stored process is run.

There is also an "unsupported" (in that it may not work in 9.2) macro that
you can get from Tech Support which allows you to update the list of values
for a given stored process. I have used that technique for a client where I
provided an EG project where there was a code node for each stored process
that ran the macro for that stored process and updated the list of values
from a data set. You could also package that approach as a scheduled job to
update all the stored processes whenever the parameter files of values
changed.

If the client will always be a browser, you can implement a UI using a
technique I describe in my book on the SAS/IntrNet Application Dispatcher
called SAS Server Pages. I have implemented that technique using the Stored
Process Server. That section of the book is provided as a sample on
sasCommunity.org:

http://www.sascommunity.org/wiki/SAS_Server_Pages

Sorry to not have better news for you.

HTH,
Don Henderson
Author of the SAS Press book "Building Web Applications with SAS/IntrNet(c):
A Guide to the Application Dispatcher"
http://www.sas.com/apps/pubscat/bookdetails.jsp?pc=60282
http://www.sascommunity.org/wiki/Building_Web_Applications_with_SAS/IntrNet:
_A_Guide_to_the_Application_Dispatcher


-----Original Message-----
From: SAS(r) Discussion [mailto:SAS-L@LISTSERV.UGA.EDU] On Behalf Of
O'Connell, Martin
Sent: Thursday, August 09, 2007 6:56 PM
To: SAS-L@LISTSERV.UGA.EDU
Subject: EG/IT and stored processes

Hi all,

We are developing some actuarial analysis routines that use EG as a front
end and connect to some databases via IT.  We are planning on the
development of stored processes to hide a lot of the messy details of the
analyses.  I am starting to develop SPs for the easier analyses now and have
a question regarding the selection lists that allow selection of parameter
values {macro vars} that get passed to the code.  Is there any way to have
these selection lists update dynamically at runtime similar to how
javascript routines can be used to perform updates to html selection lists?
At first glance selection list values get populated only when the SP is
constructed or updated and thus are static in nature.

Thanks for any help.

Martin
====================
This email/fax message is for the sole use of the intended
recipient(s) and may contain confidential and privileged information.
Any unauthorized review, use, disclosure or distribution of this email/fax
is prohibited. If you are not the intended recipient, please destroy all
paper and electronic copies of the original message.