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 »
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 »
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 »
After you have setup the cascading filter from SAS Information Map Studio, you run a test and notice that the cascading filter is not working properly. Instead of filtering on your desired variable – it returns everything. Eeek … how could this happen to a programming deity such as yourself? Let’s find out …...
Read More »
When creating prompts in SAS Business Intelligence or SAS Enterprise Guide, the value the database or your code uses to populate the field may not be user-friendly. Certainly you want your user community to think you are that cool BI developer tucked away in cubical B7-2. Hey I think you can even get yourself...
Read More »
You can do more with SAS Stored Processes than just create reports. These little suckers are packed full of power and the only limit is your imagination (and libraries where you have write access!) In this post, you will learn how to use a stored process to move a dataset to another library and not...
Read More »
For this example – I am creating a report where I want the user to only have the certain values available. If the user selects Mexico as the country then I only want states within Mexico to be available. This pictures shows you how I have the stored process code setup – nothing special....
Read More »
Building Business Intelligence Using SAS Book SAS Business Intelligence (BI) package provides an interface for multiple audiences to dissect, discover, and decide on what the data means to their organization. This book shows you the SAS business intelligence capabilities, features, and contains the most sought after tips and tricks to bring a novice user up...
Read More »
