headline »


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 …

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

Coding & Data, Enterprise Guide, Visual Analytics »

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 be delightful. It’s why I like to buy products from companies who meet my needs and delight me. In fact, her mission statement was the first thing that came to my mind when I saw this little gem in SAS Enterprise Guide.

Let SAS Enterprise Guide Delight You

If you have created data and you want to upload it to the LASR server for analysis, just click a task. That’s right – just right-click the data set name and select Load to LASR from the menu. In a few moments – your data will be waiting for you in SAS Visual Analytics.Of course – this assumes you have permission to load and can access the LASR server. [Your system administrator can assist with those steps.]

Here’s the specific steps:

  1. Right-click the data in the Project Tree then select Upload to LASR from the pop-up menu. An Upload to LASR window appears.
  2. Select the LASR library and change the metadata location if needed.
  3. Click Run.  Viola.


If your data load was successful – you’ll get a message similar to the following showing where the data was loaded. If the load failed – you will also be informed. [Need to understand the difference in SAS Enterprise Guide and SAS Visual Analytics?]

Let’s Look Under the Covers

As with any SAS Enterprise Guide task you can open it to see the code. It’s a series of 3 macros. Here’s a flow chart showing what the program does. [Tips for flow charting your SAS code]

sas code flowchart

Click to see larger image

Notice the first thing the code does is check to see if the data already exists in the LASR Server and then deletes it if it does. Unlike a database, you cannot just overwrite data – it must be replaced. This task deletes the data set with the same name. A few things to consider:

  • If there is already a data set in the LASR with the same name and does not belong to you – it will be removed
  • If you have changed the data set name – maybe you added today’s date or a “_v2” this will be considered a new data set. So don’t forget to change an existing report data source!

Make the Upload to LASR Server Code Yours

With a few simple changes – you can make this code yours. [Here’s the code as presented from SAS EG.] You may want to add it to a batch process or even a SAS stored process. In the above example, the code was loaded to the Public LASR Server.  There are three areas of the code where the data set is called by name – you can make those areas into a macro or manually change the name.

The first time it calls the data set is when the code checks to see if the data set already exists. Then when it loads the code to the LASR server – it provides the name.  Distributed VA uses the LASR procedure while the non-distributed version just uses a simple data step. The LASR procedure makes quick work of loading large tables!

sas visual analytics sas enterprise guide

The third area is when the task registers the data in metadata. It has to have this step or you won’t be able to see it in the import list. Remember if you are creating macro variables to use double quotes.

sas visual analytics sas enterprise guide

Notes:  I’m using SAS Enterprise Guide 7.1.1 for this demo.

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 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 …

Visual Analytics: 3 Tips for Brilliant Bubbles in Your Geospatial Data

2015-09-13 – 11:30 AM

I like bubble charts – even though they get a lot flack for being difficult to understand. These charts can pack a lot of data into a few variables. I agree the charts can be difficult for layperson to understand but it doesn’t seem true for the geo bubble maps. Possibly it’s because the user sees the map and understands its related to location. Here’s …

Building a Dashboard in 5 Easy Steps

2015-09-07 – 11:07 AM

Dashboards help users understand if a process or project is running smoothly. Typically, metrics are centered on some performance aspect, such as tactical objectives, time lines, or quality result. Keep in mind, the information does not present the next level of detail, which is what or why events are happening.
Dashboard Types
Dashboards be divided into two categories: Management and Operational. These categories are based on the …

SAS VA Administration: Setting up Your Security Model

2015-09-07 – 10:33 AM

One part of the Zenguard service is helping customer setup their SAS security model, which involves determining which users need to do what in the SAS Visual Analytics system. Most customers have the same basic needs – some users to view reports and some to prepare the reports.  There can be a lot of variation after that point.  Some of the report builders also administer the system …

SAS VA: Does Your Data Visualization have a Takeaway?

2015-09-07 – 10:26 AM

All the nice data visualizations in the world are worthless without a takeaway. The takeaway may be an insight about a process, a confirmation of what you thought, or lead the viewer to a way to improve a situation.  In our paper, Tactical Marketing with SAS® Visual Analytics, Hans Pasion, 89 Degrees, and I discuss how SAS Visual Analytics was used to provide all three about loyalty customers. In …