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...
Read More »
Some may not realize that you can edit a SAS Stored Process in multiple ways (depending on your permissions). Today I show you three different ways to reach the stored process code. By the way, I’m using SAS Enterprise Guide 4.3 and SAS Management Console 9.3 – so your windows may look different. Method...
Read More »
In the midst of writing our first book, Angela and I argued over the stored process chapter content. After we wrote the chapter outline, we then wrote the outline for this book. The first title was the 25 Best Tips for Writing Stored Processes. Our idea for the tips, which later became keys, was simple:...
Read More »
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...
Read More »
There are some helpful options you can set in SAS Enterprise Guide to make your day-to-day coding tasks a little quicker. Some of these tasks can impact stored processes you create from tasks instead of coding. SAS Enterprise Guide Options From the Tools > Options menu you can preset options such as footer text...
Read More »
There’s so much excitement about big data, data scientists, and all things that mean you need some serious SAS BI skills. On Monday I was discussing the Kinsey Insitiute projections for data related jobs, but even the New York Times ran The Age of Big Data an article about it. Appears everyone is talking...
Read More »
This past week I have been studying the Google Analytics data to determine the best topics to discuss in the upcoming month and to prepare the SAS Global Forum 2012 conference. Google Analytics allows me to measure which posts get the most hits when posted and continue to be popular or referenced. I’ll unveil...
Read More »
If you have spent anytime building SAS prompts for a stored process, then you might have noticed the prompts near the bottom of the list and wondered how anyone would use those or even need them. In a previous post, I showed you how to use the data library prompts. In this post, I’m...
Read More »
After some not-so careful consideration, I decided to take the SAS BI Content Developer exam. Some folks I know who have passed the exam recommended that I study how to work with SAS prompts and SAS Stored Processes. So I am making up examples and working through some exercise drills of my own creation...
Read More »
Conditional highlighting, also referred to as traffic lighting, helps report consumers quickly recognize when the data is showing the desired trends based on their targets. Today I’ll talk about the color choices for the highlighting from MS Excel, SAS Web Report Studio, and SAS Stored Processes. Conditional Highlighting Example Web Report Studio allows you...
Read More »
