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

[krusader]

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.

[AhmedAl_Attar]

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

[krusader]

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

[AhmedAl_Attar · Accepted solution]

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

[krusader]

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

[AllanBowe]

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).