Tag: prompts

Adding some culture to your SAS Enterprise Guide prompts

My teenage daughter is a self-appointed anglophile. She’s a big fan of British movies and TV shows such as Doctor Who and Sherlock, and although she has not yet visited the UK (an injustice for which she blames her father), she considers the place to be her homeland. In an […]

Taming SAS Stored Process Selection List Prompts

Author:

 
I like most things SAS.  But there are of course some features that I wish were implemented differently.  One of those is selection list prompts.  The good news is, even when SAS implements something in a way that I find, well let’s say, surprising, there is often a way to …

Post Taming SAS Stored Process Selection List Prompts appeared first on Business Intelligence Notes for SAS® BI Users. Written by . Go to Business Intelligence Notes for SAS® BI Users to subscribe.

Need “All” as a Choice for Your Dynamic Prompt?

sas bi dashboard 9.4

Author:

What I like the most about the dynamic prompts available for the stored process and SAS Enterprise Guide is that a lot of the work is done for you.  For instance, some prompts have built-in error checking and a built-in selection for selecting all values.  Without a doubt it’s one of …

Post Need “All” as a Choice for Your Dynamic Prompt? appeared first on Business Intelligence Notes for SAS® BI Users. Written by . Go to Business Intelligence Notes for SAS® BI Users to subscribe.

Make Your Selection Group Prompt More User Friendly

stored process pox at the sas global forum 2013

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 …

The post Make Your Selection Group Prompt More User Friendly appeared first on Business Intelligence Notes for SAS® BI Users. Written by .

Selecting multiple individual dates in prompted reports

The date prompt from SAS Prompt Framework provides the options of single selection or a range, however what if you need to select multiple individual dates such as Monday (May 28), Wednesday (May 30), and Friday (June 1) of last week? There are a few a…

SAS Stored Processes: 3 Tips to Improve Your Prompts

SAS stored processes are similar to SAS programs in that they use the same programming language.  Many of my SAS programs I created early on were only used by me, so I could live with  a little uncertainty and it was easy enough to check the logs for any issues.  If anything went wrong then I knew what I had to change. Stored processes required a whole new level of thinking – my first few stored processes back in the SAS 9.1.3 days were – well they left a lot to be desired.  When I would roll out a new stored process I would often get a call from a user who had done something crazy and the stored process wouldn’t work.  For instance, why would anyone put a state name in a customer name field to see if it would return all the customers from that state?  Only one thing could happen – no report!   Here’s some usability tricks that I have learned with my SAS Stored Processes to make them more robust and harder to break.  Really the out-of-the box prompts provide a lot of functionality that really helps. That’s right – let’s build a better mousetrap! Tip #1: […]

SAS Stored Processes: Excerpt from STP Book

We excerpted this post from The 50 Keys to Learning SAS Stored Processes. Chapter 2: Creating Simple Stored Processes BASE SAS gives programmers the exponential ability to query and report about data from their desktops; however, this limitation means that a user can access the data from their desktops only. As an organization’s reporting needs grow, more individuals need to quickly retrieve and analyze similar information. As a result, a small group with access to the data unintentionally becomes report gatekeepers. Other members of the organization have to talk to these gatekeepers for even the simplest piece of data. Before you convert a SAS program to a stored process, you must consider whether the program is a good candidate for conversion. Although any SAS program can be a stored process, this does not mean that all programs should be a stored process. Programs that require user input, run on user demand, and generate output are typically better candidates than those programs scheduled to run overnight, take a long time to run or require no user modifications. In Chapter 1, “Getting Started with Stored Processes” you learned how to register a stored process. In this chapter, you will convert an existing […]