Make Your Selection Group Prompt More User Friendly
Angela and I spent Sunday morning putting the finishing touches on our SAS Global Forum video, Selection Group Prompts with SAS® Stored Processes: More Power, Less Programming. While at the conference, just stop by the SAS Demo area, where the posters are displayed, to see the video. The video features a user who has contracted STP POX! It’s a dis-ease that occurs when stored process creation gets out of control. In the video you learn a method to reduce the issue with selection group prompts.
Making the Selections more Obvious
During the video, we showed a tip that we didn’t have time to discuss. When you create a selection group prompt, you want the user to select from one of your many prompt groups. However, when you do not set a default, the user may not immediately realize how much more power the prompt actually contains.
Selection-dependent (or selection group) prompts work a little different from the normal prompts. For instance, the following stored process allows the user to choose between 3 different report types: one gets the customer orders, a second pulls the trouble tickets, and the third shows the customer’s hardware returns. All of these are within the same stored process but give completely different output for the user. Plus this stored process reduced 6 stored processes into 1. Sounds like someone got some STP POX vaccine.
As you can see in the before and after images, once you run the stored process the defaults are remembered from your last run. The next time you run the stored process, it is less obvious the prompt allows the other choices – even after you reset the prompts. So a quick fix is to add a choice that explains what to do, as shown in the After image.
Set the Default for the User
Add a new choice to your selection-dependent prompts that instructs the user what to do, such as “Select a report type” and make it the default. This new choice ensures the user understands what is possible.
Thanks to the user from Pennsylvania who shared this suggestion with me. She was having an issue in her organization and thought other SAS developers could benefit from this tip.
Learn More about SAS Stored Processes and Prompts
You can learn more tips and tricks for creating, debugging, and using SAS stored processes in the 50 Keys to Learning SAS Stored Processes book. It's a complete guide to SAS stored processes. Check Amazon for best pricing and quick shipping!
Latest posts by Tricia Aanderud (see all)
- Seven Interesting Data Storytelling Examples - 2018-06-09
- Use Network Analysis to Understand Your Customers with SAS Visual Analytics 8.2 - 2018-01-21
- My 7 Favorite Features in SAS Visual Analytics 8.2 on Viya - 2018-01-14
- Designing Dashboards: Finding the Fantastic Five Colors - 2017-06-19
- Creating a Web Analytics Report in SAS Visual Analytics 8.1 - 2017-06-19
Tags: Stored Process Tricks