topic Using results from a stp, as input parameter values for another stp. in Developers

Using results from a stp, as input parameter values for another stp.

chandru1dev — Wed, 09 Jun 2010 09:02:46 GMT

I am executing a stored process in EG.
For the stored process I need the input parameters to be picked from a parameter dataset which gets updated periodically.

So I plan to write another stored process which accesses the data set and presents the user with the dynamic list and then invokes your current stored process.

How can I execute this in EG?

Thanks,
Chandru.

Re: Using results from a stp, as input parameter values for another stp.

Cynthia_sas — Wed, 09 Jun 2010 11:18:22 GMT

Hi:
I believe that dynamic and cascading parameters are supported in Stored Processes in the SAS 9.2 Platform. Consult the documentation for more information on how to implement these kinds of parameters.

cynthia

Re: Using results from a stp, as input parameter values for another stp.

chandru1dev — Wed, 09 Jun 2010 11:45:16 GMT

Hi Cynthia,

Thanks for the reply, I am working in SAS 9.1.3 platform.
Is there any other option for this.

~ Chandru Message was edited by: chandru1dev

Re: Using results from a stp, as input parameter values for another stp.

chandru1dev — Wed, 09 Jun 2010 11:59:36 GMT

Hi Cynthia,

I am working in SAS 9.1 platform. Is there any other option for this?

Thanks,
Chandru.

Re: Using results from a stp, as input parameter values for another stp.

Cynthia_sas — Wed, 09 Jun 2010 13:22:04 GMT

Hi:
In EG, you can populate the initial parameter selection list from a CSV file or from a SAS dataset. However, this definition is static and will not change (in SAS 9.1.3) when the underlying data changes. I believe there are ways to update the metadata or using JSP pages to create dynamic lists. Consult the developer's documentation for SAS 9.1.3 Platform or work with Tech Support for the approach that best suits your installation and your skills.

cynthia

Re: Using results from a stp, as input parameter values for another stp.

Vince_SAS — Wed, 09 Jun 2010 13:28:48 GMT

Take a look at this thread, specifically toward the bottom, where I mention the STPDefineParameter macro.

http://support.sas.com/forums/thread.jspa?messageID=1943

Vince DelGobbo
SAS R&D

Re: Using results from a stp, as input parameter values for another stp.

chandru1dev — Tue, 15 Jun 2010 13:58:49 GMT

Hi,
Thanks everybody for the replies.

I used the technique to refresh the metadata for the particular stored process, after my monthly job completes. Using unix script job to refresh metadata.
Since the data changes once a month, I chose to use this option.

Thanks,
Chandru