topic Re: Stored Process Prompt issue in Developers

Stored Process Prompt issue

rajiv436 — Fri, 17 Jun 2016 09:33:08 GMT

Hi ,

We've a problem in stored process excecution. we have selected a dynamic list in one of the prompts, In that the values are not retrieving to display from the selected table of dynamic list. Selected table for dynamic list and other tables used in the stored process belongs to same library.

Key points:

we are successfully getting the values list in the prompt only before the exection of using Library with libname statement.

If we're not executing the libname statement, before running the storerd process its not poping the list in the prompt.

Here I've attached some screenshots and the code used in the stored process.

Re: Stored Process Prompt issue

Kurt_Bremser — Fri, 17 Jun 2016 10:01:48 GMT

I don't see any code in your screenshots, but I guess you need to define your library in the metadata so that it is automatically assigned by the stored process server.

Re: Stored Process Prompt issue

rajiv436 — Fri, 17 Jun 2016 11:39:48 GMT

That Library is already registered with Meta data.

Please find the code below we are using.

Re: Stored Process Prompt issue

Kurt_Bremser — Fri, 17 Jun 2016 11:57:09 GMT

To verify that the library definition is not the culprit, I'd create a simple STP that reads data from a dataset in that library (without explicit libname for that library in the STP) and test that.

Re: Stored Process Prompt issue

rajiv436 — Fri, 24 Jun 2016 10:04:23 GMT

AS per the update from SAS Technical support, To generate the values dynamically, the table used in the prompt should belongs to the same library of other tables used in the program, I already have the program in the same manner, then also it won't work.

May I get any additional information to resolve this issue.