headline »

SAS Visual Analytics: Get to the Point with a Geo Coordinate Map

August 30, 2015 – 11:52 am | Comments Off on SAS Visual Analytics: Get to the Point with a Geo Coordinate Map

Perhaps you’ve heard people talk about tornado alley – it’s an area down the middle of the US where tornadoes occur. Tornadoes are powerful storms – capable of sending a 2×4 wood board through a car door – scary.  In the first post of this series, I noted that successful geospatial data visualizations have geography as a character in the data story. If we wanted …

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

Data Visualization, Visual Analytics »

SAS VA: Is Location just a Distracting Character in Your Dataviz?

August 24, 2015 – 2:29 pm | Comments Off on SAS VA: Is Location just a Distracting Character in Your Dataviz?

maps_all_rileyIn my high school Performance Art class, our teacher, Mr. Kennedy, was constantly reminding us that when you have characters on stage the focus must remain on the central action. If you have non-speaking role then you cannot draw attention to yourself. For instance, you wouldn’t tap your foot, play with your hair or wave to the audience members.  This concept can translate into a data visualization as well – especially with geospatial data. If the location isn’t the main character, then it might just be a distraction  – much like Riley the Cat who was supposed to be a curious bystander.

Reviewing Geospatial Objects in SAS Visual Analytics

Before using SAS Visual Analytics, I only had PROC GMAP available to produce what I would call some fairly uninspired data visualizations. SAS Visual Analytics changed my capabilities with its 3 geospatial objects: Geo Bubble, Geo Coordinate, and Geo Region.

sas visual analytics review geo maps

Each geospatial object has advantages over the others depending on what takeaway you want to provide the viewer. This proceeding graphic shows an overview so you have an idea of how they are different. In this four-part geospatial series – we will cover when to use geospatial objects and I will talk about each one and explain when it makes sense to use each.

Is Location Really a Part of the Story?

Earlier when I was talking about being on stage – I was alluding to the fact that when you start doing something that draws attention to your character – the audience might not realize you are not really part of the story. Is the same with geospatial objects, since SAS Visual Analytics makes it so easy to draw a map you might think it is part of the dataviz.

It’s up to you to review your data story and decide if location is really part of your story. Is geography a character – does it have a role or is this just something cool you can do? Let’s talk about when it makes sense and when it doesn’t.

Location as a the Main Character

If you want to show that your customers live close to your stores that’s a great reason because it helps the viewer understand the geographic distribution – it’s part of a story. In the following example, the map shows that more in-store purchases were from those who lived closer to the store.  [This is from my SGF2015 paper about Tactical Marketing.] The bubbles plot ZIP codes and the size shows revenue. Maybe you can imagine this story explains where you want to spend advertising dollars. The geography is part of the story because the customer’s location matters.


Location as a Distracting Extra

Author Dona Wong (Wall Street Guide to Information Graphics) suggests that there are times when geography is not part of the story so it doesn’t make sense to force it to be. In her example, she shows two sales regions (Texas vs New Jersey) where sales were higher New Jersey than Texas.  The problem is that regions are so disproportionate in size that comparing the total sales is not helpful and did not lead to any conclusion except that the Texas store was not generating as many sales. The story was about revenue not about where it was being generated.

I’ve recreated the example in the following graphic. You can see her point – we don’t know why Texas has so little revenue compared to the northeastern states. I can think of reasons such as there are less stores in Texas, the store only sells snow supplies, or maybe the store just opened. I think Dona Wong’s point was that the map doesn’t really explain anything and only invites confusion. What do we want the viewer’s takeaway to be? We have stores in 3 states but no one shops at the one in Texas?


Do Weather Events Seem Location Based?

For this blog series, I pulled the storm events data from the National Climatic Data Center website.  This database contains US storm events (like tornadoes, thunderstorms) since 1950. In most cases there are other facts such as number of deaths or injuries and the estimated property damage. The tornadoes are rated by their intensity on the Fujita Scale from F0 to F5 with F5 being the most harsh. In 2007, the enhanced Fujita Scale was introduced and tornadoes were categorized as EF0-EF5.

Is Your Data Ready?

The storm event data already had useable geographic data – there was US state name and FIPS codes for state and county. Nearly all of the tornadoes had latitude and longitude values for where the tornado started and ended. The state and latitude and longitude can be imported to SAS Visual Analytics without an issue. Here’s an example of how the data look in SAS Enterprise Guide.


SAS Visual Analytics 7.1 and later accepts geographical data items as either name, ISO 2-Letter codes, ISO Numeric Codes, or SAS Map ID values. This varies based on what element you are using country, region, and state/province values are most widely accepted.  When you assign a data item to Geography these are your choices.  [Refer to the SAS documentation for your release for more details.]


Here’s an example from the SAS Support of how SAS Visual Analytics expects to receive that geographic data. You can use the SAS/GRAPH MAPSGFK library  to join your data to a SAS dataset that has this values. For instance, I joined the storm event data with the MAPSGFK.US_ALL dataset by the state FIPS codes to get abbreviated state names.


You can also build a custom data item based on the latitude and longitude and it’s really easy! We will talk more about that in Learning to Use Geospatial Objects Part 2 and learn how to use a Geo Coordinate map.

Attending SESUG 2015?

If you are planning to attend SESUG 2015 in beautiful Savannah, Georgia on Sept 29 then join me for my talk about data visualization "How to be the MacGyver of Data Visualization"!

Never miss a post!

Get the latest BI Notes post in your Inbox when a new post is released! Click here for free subscription. You email address is kept private and you can unsubscribe anytime. Go ahead ... join us!

How Not Knowing Pie Charts Makes You a #DataViz Rookie

May 7, 2015 – 10:15 am | 5 Comments

If I live to be 115 years old, I’ll never understand why consultants use pie charts. Your chance of doing them wrong is greater than doing them right. At the SAS Global Forum last week, I was delighted to hear several others telling me how much they hated pie charts and we agreed, they need to be stomped out – we are forming a #DataVizArmy …

Data Visualization is on Tap at #SASGF15

April 22, 2015 – 7:30 am | One Comment

This post first appeared on The 10 Minute SAS Coach site.  Thanks Guy Garrett for contributing to BI-Notes.
The SAS Global Forum is an event where SAS professionals from around the world meet once a year to see the latest R&D from SAS Institute, discuss current trends in Business Intelligence, Analytics and Big Data, and hear papers from colleagues on all manner of subjects ranging from Arrays …

6 Tips for Data Visualization from a Floral Designer

March 26, 2015 – 7:35 am | Comments Off on 6 Tips for Data Visualization from a Floral Designer

You never know where you will find inspiration. This past weekend I attended the NC Museum of Art Art in Bloom Festival.  The idea is that local floral designers use a museum masterpiece to draw inspiration for a floral design. [More: WRAL video about event] It was incredible to see how someone could paint with flowers. Turns out there are many Art in Bloom events like …

SAS Coding: Use Flowcharts to Learn Inherited SAS Code

March 2, 2015 – 8:00 am | 5 Comments

I’m a visual person – I always need a picture. As a consultant, many times I’m given a thumb drive full of code and asked to make modifications.  When you are on a project with me, you’ll grow weary of hearing me say “Can you draw it?” Something magical happens for me when I see a flow or see an idea.
One of the most confusing projects I …

Wanted! SAS Rustlers Unite at #SASGF15 #TweetUp

February 22, 2015 – 12:23 pm | 9 Comments

In April 2015, SAS users travel across the world to the SAS Global Forum in Dallas, Texas – yes the legendary Wild West.  If you are arriving early at the conference (maybe for a workshop or to take a certification exam) – then you’re invited to a special and exclusive event.

#SASGF15 Tweeps Unite!
This is an informal, pre-conference gathering for tweeps on Saturday 25th April at 8 PM at the conference hotel. …