headline »


SAS Visual Analytics: Bubble Plots for Less Toil and Trouble

2016-04-24 – 12:55 PM

You cannot research bubble plots from any data visualization expert without reading a reference to the Hans Rosling’s Ted Talk Let My Dataset Change Your Mindset. It may have been the first time a bubble plot gained a mainstream appeal noted Stephen Few in his Show Me the Numbers book. Rosling provided an intense amount of information in one data visualization and he changed my mindset. Here’s some …

Read the full story »
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

Visual Analytics »

SAS VA Data Builder: Add a New Data Item

2016-02-05 – 9:25 AM

The SAS Visual Analytics Data Builder allows you to prepare and load data to the SAS LASR Server so you can complete analysis or build reports and dashboards. It’s a little more tricky to use than some of the other parts of SAS Visual Analytics but can usually be mastered within a day. If you need to add a data item to your data table, just click the plus icon to get started.

Using the Data Builder

The Data Builder is not meant to be used by everyone generally it’s limited to a few users who are familiar with the data sources. Most customers use it to load data from a data source such as a database or Hadoop. The Data Builder can join tables and load data to the HDFS and LASR Server. It can also be used to schedule jobs  You can also code in the Data Builder if you want to use IMSTAT procedure or some other select procedures.


Adding a Calculated Data Item to the Output Table

You can use the Data Builder to build the output data source or what you want loaded in to the LASR Server to use in your reports. In this case, I used the HEART data from the SASHELP library. The data contains statistics about heart patients from the e Framingham Heart Study.

After adding the HEART data table, I added a few columns of interest.  I don’t want all of the data for this example. To add a new data item, click the Plus icon, type the name, select the type (Number, Character, Date, etc) and type your expression. In some cases your expression may be simple enough that you can type it in the Expression field, but you can use the Expression window if it’s a bit more tricky.


In this instance, I want to add the Body Mass Index calculation to the other factors in the HEART table. When I click the Expression icon, the following window appeared.  It allows me to type the formula and pull the data items that I want to use. You can see I have the formula based on the Height and Weight items.


When I save the data query and preview the data, you can see my new BMI column.


What is it Doing?

Behind the scenes the Data Builder is writing SQL code. If you click on the Code pane, you’ll see all the code needed to complete the query. You may have to scroll down to see your specific SQL procedure. If you are handy with the SAS code then you can unlock the code and work on here. Just remember, once you unlock the code there is no going back!



Adding a Data Item with a Format

You can also apply a format to a data item to create a new data item. In this instance, I have the Candy tables from the SAS Enterprise Guide samples. In this case the month name is stored as a number and we want to see it as month name.  When I added the Month_Num data item, I changed it to Date type so the monname. format would be available.


To see the formats, click on the Format column to see the Select a Format window. Scroll to the MONNAMEw. format and select how you want the month name to appear. For instance, when Width is set to 9 the entire name appears, but when you select 3 only the first 3 letters of the month name are shown.


Here’s what it looks like when I view the result.  I added two data items so you could see the difference in the 9 vs 3 width.


And here you can see how the code applied the format. Also remember the label is what the user’s see when building reports or explorations.



That Was Painless …

Adding data items is a painless task – you just need a few pointers. What you may have noticed is that all of your data needs to be in a SAS readable format, such as a SAS dataset or SASHDAT table if coming from the HDFS.

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.


3 Methods to Remove Data from the HDFS VAPUBLIC Directory

2015-12-20 – 3:53 PM

When working with HDFS, you are often loading data to the various directories to upload into SAS Visual Analytics. However, sometimes you want to remove that data. Here’s three different ways to remove the data.
Method 1: Use the SAS VA Administrator Tools
If you have access to the Manage Environment area, you can use the Explore HDFS tab to interact with the data in the HDFS. You …

SAS VA: Dealing with Missing Dates

2015-12-20 – 1:27 PM

It’s nearing the new year and you may have already started preparing reports that have the organization’s goals and the progress toward those goals. However your chart may not be displaying correctly. If your data is not setup properly then you’ll notice that you only have one or two months when you want to see the entire year even if there is no data yet. …

Adding a Stored Process to SAS Visual Analytics

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 …

Oh Snap! Upload Data to the LASR Server Just Like That!

2015-10-24 – 7:55 AM

In a past life I worked at a company who had an excellent general manager, she was professional, intelligent, and a role model. It was a small company competing with giants and kicking their butt successfully. She set a new mission for the organization –  we needed to not only meet a customer’s product needs but also delight them in the process. Its hard to …

3 Quick Steps for Using External Links to Enrich Your SAS VA Report

2015-10-04 – 3:17 PM
sas visual analytics twitter report

If you read my Thanks for the Negative Tweets Josh post on LinkedIn then you know that I’ve been working on some Twitter reports in SAS Visual Analytics. My goal is to have a set of reports that I can use for demos, training, blog posts, web-inars, and even eBooks.  In my current draft the biggest challenge is determining what Twitter data tells an interesting story and provides …