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 […]
Tag: prompts
Taming SAS Stored Process Selection List Prompts
Author: Quentin McMullen
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 Quentin McMullen. Go to Business Intelligence Notes for SAS® BI Users to subscribe.
Need “All” as a Choice for Your Dynamic Prompt?
Author: Tricia Aanderud
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 Tricia Aanderud. Go to Business Intelligence Notes for SAS® BI Users to subscribe.
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 …
The post Make Your Selection Group Prompt More User Friendly appeared first on Business Intelligence Notes for SAS® BI Users. Written by Tricia Aanderud.
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 […]
Peek Inside SAS BI Book: Building Business Intelligence with SAS
You may be aware by now, our new SAS BI book Building Business Intelligence with SAS:Content Development Examples launched last week on the SAS Press site. That’s right, SAS Press or Amazon will be delighted to bring a copy of this SAS BI book to your door. When Angela and I set out to write this book, one of the first things we discussed was how new users get access to the SAS BI toolset and have no idea of its astonishing capabilities. This book guides you through each one so you understand it. Intermediate and advanced users will also find this book as a valuable reference. Several times, Angela & I have both found ourselves pulling out the draft copy to reference an advanced technique. This book fulfills a unique spot in the marketplace; there is no other single book that leads you through each SAS BI component with step-by-step examples along with hundreds of tips and techniques to make you successful! SAS Institute offers over nine SAS BI courses to cover all the topics we have jammed packed into this book. Making this an excellent study guide for those planning to take the SAS BI Content Development Exam. Your SAS […]