What Can I Do With a Stored Process?

February 26, 2012

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

Often I refer to SAS Stored Processes as the workhorse of the SAS BI tools … you can use these little devils everywhere sometimes as Band-Aid, sometimes as the star, and sometimes as a background player. In a past post, I showed you how to use a stored process to add dashboard dials to Web Report Studio and Linking to a Stored Process from Web Report Studio.

Add-In for MS Office – View Reports or Data

Use the stored process to deliver a report or maybe just a dataset (using Proc Print) to the Add-In for Microsoft Office (AMO). In the past, I set up several stored processes that only contained a PROC PRINT to display a data set. Then I added a prompt for Product, which allowed the user to query product inquiries based on the product of interest.

Here’s how you access the stored process from AMO 4.3. This works similarly in prior versions of AMO.

  1. Open MS Excel (or Word/PowerPoint). On the SAS ribbon, click the Reports icon.
  2. Navigate to the stored processes storage location and click the stored process name.
  3. < Optional> This stored process has two prompts: Visitor Type and ODS Style. Your stored process may not have any. These can be changed later if you want to use different
  4. From the Choose Location window, select where you want the output placed. I selected a New
    Worksheet and used the default name. You can see the stored process returned a short report.

022612 1439 WhatCanIDoW1 What Can I Do With a Stored Process?

Adding to the SAS Portal

You can add a stored process to a portal page. Simply add a Stored Process Portlet and click the Edit button on the menu bar. Navigate to the stored process location and select it. If there are prompts associated with the stored process, you can see the value in the stored process parameters area.

022612 1439 WhatCanIDoW2 What Can I Do With a Stored Process?


Behind the Scenes Stored Processes for BI Dashboard

You can use a stored process to support other clients. For instance, you can use a stored process as a data source for the SAS BI Dashboard, as shown below. Create a new data indicator and select Stored Process as the data source. Then use the Browse button to navigate to the stored process. Once you add the stored process, the stored process executes and returns the data to the Preview area. Notice that the data set name (an_prdsale_example) is shown in the Published data set name field.  

022612 1439 WhatCanIDoW3 What Can I Do With a Stored Process?

What else can you do?

Here’s some other ways you can use stored processes:

  • Use in Information Map Studio to query the RDBMS to return data to the information map or as a way to provide a prompt to the information map.
  • Use a custom graph in the SAS BI Dashboard.
  • Allow the BI Dashboard to link to a stored process where you can display a very custom report.

How have you used stored processes – tell me in the Comments section below.

Learn More about SAS Stored Processes and Prompts

You can learn more tips and tricks for creating, debugging, and using SAS stored processes
in the 50 Keys to Learning SAS Stored Processes book.
Also the book has examples of using single, grouped, and selection prompts with 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.

Tags: , , , , , ,


SAS-X.com offers news and tutorials about the various SAS® software packages, contributed by bloggers. You are welcome to subscribe to e-mail updates, or add your SAS-blog to the site.


Dear readers, proc-x is looking for sponsors who would be willing to support the site in exchange for banner ads in the right sidebar of the site. If you are interested, please e-mail me at: tal.galili@gmail.com
SAS and all other SAS Institute Inc. product or service names are registered trademarks or trademarks of SAS Institute Inc. in the USA and other countries. ® indicates USA registration.