Peek Inside: The 50 Keys to Learning SAS Stored Processes

This post was kindly contributed by Business Intelligence Notes for SAS® BI Users - go there to comment and to read the full post.

Release Date: Apr 2012

Purchase Here – $44.95

Download Sample Chapter

In the midst of writing our first book, Angela and I argued over the content of the stored process chapter. We knew we could not cover all the topics that deserved attention. After we wrote the outline for that chapter, we then wrote the outline for this book. The first title was the 25 Best Tips for Writing Stored Processes. As we started writing the book, the tips grew from 37 to 43 to 55. Finally, we agreed on a nice round number – 50.

Our idea for the tips, which later became keys, was simple: take a simple SAS program and show how that program can be modified into several different stored processes. By following this process, you build on your knowledge from the previous chapter as you learn the new techniques.

Careful – once you realize how easy it is to create powerful stored processes, you might find yourself making up excuses to write them!

Enhanced Learning Path

We wanted to make learning the code easier to learn. So we developed a table method where the code you are writing is on the left and the explanation is on the right. [Double-click image to zoom in]
We used different fonts so you could easily understand how the code changed. For instance, code you need to delete uses a strike-through and inserted code is shown in blue. Any code that remains the same is shown with a gray background. In some stored processes, you may only need to add a line and delete a line to have a completely new stored process. It’s not that clear in other teaching methodologies.