Your SAS programs, embedded in web apps and elsewhere

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

Accepted Solution Solved
Reply
Occasional Contributor
Posts: 7
Accepted Solution

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

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.


Accepted Solutions
Solution
‎10-18-2017 04:41 PM
Regular Contributor
Posts: 222

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

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

View solution in original post


All Replies
Regular Contributor
Posts: 222

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

Try changing the &_action= parameter value to &_action=PROPERTIES,RECALL
Occasional Contributor
Posts: 7

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

Posted in reply to AhmedAl_Attar
Unfortunately no luck here, &_action=PROPERTIES,RECALL does not help to display the prompts above the result table after the stored process runs
Solution
‎10-18-2017 04:41 PM
Regular Contributor
Posts: 222

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

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

Occasional Contributor
Posts: 7

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

Posted in reply to AhmedAl_Attar
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
Contributor
Posts: 24

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

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

 

 

/Allan
Think you know SAS? Take the sasensei challenge..
☑ This topic is solved.

Need further help from the community? Please ask a new question.

Discussion stats
  • 5 replies
  • 242 views
  • 0 likes
  • 3 in conversation