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 » Stored Processes, Visual Analytics

Adding a Stored Process to SAS Visual Analytics

Submitted by on 2015-12-01 – 7:04 AM

Not all data belongs in SAS Visual Analytics – it’s true. You may have situations where you want to filter and zoom on data and then look at the data in another system. Maybe it’s a list of items that the user wants to follow-up on in a different method. If you are using a non-distributed version of SAS Visual Analytics you may be particular about how much data does go into the system.  In these cases a SAS Stored Process allows you to pass a parameter to another data set and output to HTML or even Excel.

Linking to a Stored Process

Let’s look at an example of how I envision this process working. In the following figure, I have two datasets: DSN1 and DSN2. DSN2 is a data set that contains all tweets during the past year about a particular hash tag. Many times when people are analyzing social media they are evaluating counts of tweets, counts of retweets, hashtags that are used, and so on. They are actually less interested in the tweet itself at first. Tweets can use a lot of space. Thus you don’t want all of that data in the LASR server- so you have a second data set called DSN1 that contains summarized information from the past week. However, when you do want to review the tweet text then its nice if you could retrieve the detailed data.  You may decide to load the data in the Explorer for text analysis.

The following chart shows an overview of how the stored process is going to work. The key is having a common variable that is available in each data set. In this case the variable is author_id. When the user runs the stored process, it passes the selected author_id to the stored process so we can see all the tweets from that particular author.

2015_va_stp1_overview

Here’s an example of how it looks. When the user clicks on an author name a pop-up offers to show the tweets in Twitter or in a file. When the user selects Export data to a file, a web page opens with the selected authors’ tweets. You can also output to other formats such as CSV, Excel, PDF, RTF, and so on.  Notice that the SAS Visual Analytics report object must have the author available to pass to the stored process.  If the chart contains a list of tweet locations, then the author_id would not be available to pass to the stored process.

2015_va_stp1_link

Setting Up Your Stored Process

Here’s a brief overview of how to recreate this process. For additional details about using stored processes, refer to the user guide for your release of SAS Visual Analytics.

  1. Create a stored process that uses the common variable in a where statement and use that as a prompt value. In this case author is my prompt.
    Your stored process code should look similar to this code:2015_va_stp1_stp_code
    Here’s an example of how to use a dynamic where clause if you want to use the stored process for multiple queries. For instance if you wanted to select author, region, or hashtag, you first need to know what the user actually selected.
  2. Create a report in SAS Visual Analytics using the data set with the common variable, such as author or order_id. Your data object must contain the data item that will be used in the stored process. In the above stored process it was called author. In the following figure, you can see the bar chart lists the tweets by author.
  3. Right-click on the data object (bar chart, table, pie chart) and select Add Links > External Links.2015_va_stp1_ext_link
  4. In the Create External Link window, select Link to stored process and find the stored process you created in Step 1 and associate the parameters from the data object with the prompt.  Author is what is showing in my data object as the y-axis value so I can pass it to the prompt.  The data item do not have to have the same name just the same value.Note: If your parameter is not shown, then select the Add a new parameter to create it.2015_va_stp1_ext_link_to_stp
  5. Click ok and test.

Have you used stored processes with your SAS Visual Analytics reports? Tell me about it in the comments below.

 

Never miss a BI Notes post!

Click here for free subscription. Once you subscribe you'll be asked to confirm your subscription through your email account. You email address is kept private and you can unsubscribe anytime.

 

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: , ,