topic Stored Process - Display Prompt Filters above Results to re-run stp with different filters in Developers

Stored Process - Display Prompt Filters above Results to re-run stp with different filters

krusader — Mon, 01 May 2017 18:07:47 GMT

In a stored process I've created prompts before that come up before the stored process runs. How can I have these prompts available above the table of data that returns? I'd like to be able to change prompt values and re-run the stored process from the same page, after searching around I am uncertain where this sort of configuration would go.

Re: Stored Process - Display Prompt Filters above Results to re-run stp with different filters

AhmedAl_Attar — Mon, 01 May 2017 18:57:56 GMT

Try changing the &_action= parameter value to &_action=PROPERTIES,RECALL

Re: Stored Process - Display Prompt Filters above Results to re-run stp with different filters

krusader — Mon, 01 May 2017 19:56:49 GMT

Unfortunately no luck here, &_action=PROPERTIES,RECALL does not help to display the prompts above the result table after the stored process runs

Re: Stored Process - Display Prompt Filters above Results to re-run stp with different filters

AhmedAl_Attar — Tue, 02 May 2017 14:25:19 GMT

You probably will have to use Custom Form in this case, with Framesets (Upper section/frame for the Parameters, Lower section/frame for the Stored Process Execution Results)

Check the following SAS Documentation for examples and detailed instructions

- SAS 9.3 Stored Processes: Examples

Not knowing which version of SAS you have, Check out the corresponding SAS Stored Processes: Developer's Guide for your SAS version

Hope this help,
Ahmed

Re: Stored Process - Display Prompt Filters above Results to re-run stp with different filters

krusader — Wed, 18 Oct 2017 20:42:34 GMT

This is correct that a custom form is needed. There is plenty of documentation on this after I read up. It requires a data _null_ step and a file _webout to stream the put html back to a web page

Re: Stored Process - Display Prompt Filters above Results to re-run stp with different filters

AllanBowe — Wed, 18 Oct 2017 21:13:58 GMT

Building your web front end as a Single Page Application with SAS at the backend is a great design choice 🙂

You essentially need to serve your HTML / CSS / JS from the web server directly, and call SAS using ajax (or better - our open source h54s adapter).

For a quick guide to this approach you can checkout this blog or peruse the excruciating step by step details in this SGF 2017 paper. The paper actually gives you what you describe (a filter which shows the data underneath), the source code / seed app is also on github.

For testing / improving your knowledge on Stored Process Web Apps you can also peruse the SPWA tag on sasensei.com (which is still in beta mode).