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

[chandru1dev]

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.

[Cynthia_sas]

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

[chandru1dev]

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

[chandru1dev]

Hi Cynthia,

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

Thanks,
Chandru.

[Cynthia_sas]

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

[Vince_SAS]

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

[chandru1dev]

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