BI Tools

Tips and tricks for building information maps, OLAP cubes, reports, and dashboards

BI Admin

Learn your way around a SAS BI installation.

Visual Analytics

Learn your way around the SAS Visual Analytics tool

Coding & Data

Extract, transform, and load your data into the SAS BI toolset

Stored Processes

Create and design stored processes like a rock star

Home » BI Tools, Enterprise Guide, Stored Processes

Peek Inside: The 50 Keys to Learning SAS Stored Processes Book Available!

Submitted by on 2012-04-15 – 9:00 AM

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: take a basic SAS program and show how that program can be modified into over 25 different stored processes. By following this process, you build on your knowledge from the previous chapter as you learn the new techniques. Here’s some highlights from the book – which is available for purchase today!

See the winners!

Enhanced Learning Path 

You need a way to learn the code that is simple! 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.

 

 

What are the Keys?

Each chapter contains keys or tips to help you remember key concepts about the topic. Here’s a few samples:

 

Working with Complex Prompts

We’ll show you how to code simple and complex prompts! These prompts can help you turn three stored processes into one, which simplifies maintenance. 

 

Complex Layouts

Sometimes the stored process has to go beyond the out-of-box layouts. Learn how to create the layout and how to create output.

 

 

 

 

 

 

Also create code that can be used in mobile devices – such as an iPhone or iPad.

 

Learn to use HTML and JavaScript

Adding HTML and JavaScript to your stored processes to create customized layouts and reports.

You can add custom drop-down menus, create drill-downs to other stored processes, and learn to use HTML forms to collect user input.

 

 

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

 

 

Order Your Copy ”yes””Download ”yes””Download

 

The following two tabs change content below.

Tricia Aanderud

Director of Data Visualization at Zencos Consulting
Tricia Aanderud is a SAS Business Intelligence and Visual Analytics consultant based in Raleigh, NC who works for Zencos Consulting. She has written several books about SAS, presented papers at many SAS conferences, and has been using SAS since 2001. Contact her for assistance with your next project.

Tags: , ,

No Comment »

2 Pingbacks »