topic Re: "Daisy Chain" Prompt Windows?? in SAS Enterprise Guide

"Daisy Chain" Prompt Windows??

chris_lampron — Fri, 27 Feb 2015 20:37:52 GMT

Is it possible in SAS Enterprise Guide 5.1 to have multiple windows of prompts? For example, if the user selects a "yes" or "no" from a drop-down prompt and clicks on the "RUN" button, it will load another window of prompts based on the selection of the user?

What I am trying to do is have certain prompts suppressed based on the drop-down selection from the user. The drop-downs are a static list of options that I have setup.

I have searched online and through multiple SAS papers, but have been unsuccessful at finding any solutions.

Any help would be greatly appreciated.

Thank you.

--Chris.

Re: "Daisy Chain" Prompt Windows??

Reeza — Fri, 27 Feb 2015 22:00:20 GMT

Cascading prompts?

Re: "Daisy Chain" Prompt Windows??

chris_lampron — Mon, 02 Mar 2015 12:32:51 GMT

I wasn't thinking cascading prompts. Those require dependency's on previous prompts. Also, they require a dynamic list. The prompts that I currently have in my stored process are all static.

What I was wondering is, when you run the stored process, the prompt window appears. The user will then fill in all of the prompts and click 'Run' at the bottom. Based on the choices here, a second prompt window would appear with additional prompts for the user to input before the program runs.

The reason I am asking about this is because there are a few prompts that I was looking to suppress or have on a second window based on the first and second prompt selection. Depending on what the user chooses, a few prompts may not be required.

I have been looking around online for some time now, and the only option that I have to go with is make certain prompts not required to run the program. So instead of not suppressing the prompt, the user could leave it blank. But it would look cleaner if the prompt was just hidden or grayed out.

Re: "Daisy Chain" Prompt Windows??

Kurt_Bremser — Mon, 02 Mar 2015 13:29:33 GMT

In that case, I would either try to use javascript in a dynamically generated web page that calls the STP, or have a primary STP that does all the prompts (repeatedly calling itself with status parameters) and then calls the "real" STP that does the work.

Re: "Daisy Chain" Prompt Windows??

gergely_batho — Tue, 03 Mar 2015 11:46:28 GMT

If the content of the prompts is available before running anything, then you need selection groups:

http://support.sas.com/documentation/cdl/en/stpug/67499/HTML/default/viewer.htm#n04zozyzrfsilkn10wjvid5tfsat.htm

If the content of the second prompt is dynamically generated @KurtBremser 's suggestion works. Also see chaining Stored Processes:

SAS(R) 9.4 Stored Processes: Developer's Guide, Second Edition

But this is useful only if you use SPs throug the web interface, not EG.

Re: "Daisy Chain" Prompt Windows??

ChrisHemedinger — Tue, 03 Mar 2015 13:14:31 GMT

We do have a custom task that allows you to build in a simple prompt anywhere within your SAS Enterprise Guide process flow:

http://blogs.sas.com/content/sasdummy/2013/10/08/process-interruptus-a-custom-task-to-pause-your-process-flow/

You might be able to use this to design the workflow that you want. Combine it with process flow dependencies (user-defined links between tasks) and maybe even Conditions within the process flow. The prompt types are very simple and not dynamic, but have a look and see if it gets you further...

Chris

Re: "Daisy Chain" Prompt Windows??

chris_lampron — Fri, 06 Mar 2015 20:34:03 GMT

Thank you gergely.batho,

I was able to use the selection groups to get the prompt window to function properly.