Your SAS programs, embedded in web apps and elsewhere

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

Reply
Occasional Contributor
Posts: 15

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

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.
SAS Super FREQ
Posts: 8,743

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

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
Occasional Contributor
Posts: 15

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

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
Occasional Contributor
Posts: 15

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

Hi Cynthia,

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

Thanks,
Chandru.
SAS Super FREQ
Posts: 8,743

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

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
SAS Employee
Posts: 285

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

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
Occasional Contributor
Posts: 15

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

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
Ask a Question
Discussion stats
  • 6 replies
  • 299 views
  • 0 likes
  • 3 in conversation