Dealing with Dates in SAS Visual Analytics Designer

In a previous blogVisual Analytics audit data collection, I discussed SAS date and time values, and how date and time formats can be used to your advantage in SAS Visual Analytics. That blog addressed some of the features provided for handling date information, like date formats, date hierarchies, and calculated data items based on time intervals.  In this blog, I’ll continue this discussion and share some tips and techniques for working with dates.

Problem: How do I calculate passage of time?

Example: Out of concern over the time taken for delivery of a certain product, we’d like to take a look at the time, from order to delivery of the product, for each order across several years.  The table in memory has data items Product ID, Order ID, Date Ordered, Date Delivered.

Date in Visual Analytics Designer01

Read More »

Post a Comment

Use parameters to pick your metric in Visual Analytics Reports

Look at the report below. Imagine being asked to allow your users to select which Measure, highlighted in yellow, they are looking at: Income, Expense or Profit. This is a frequent report requirement and I’m going to outline just one of the ways you can design your report to satisfy this request using parameters.

In a previous blog, I talked about Using parameters in SAS Visual Analytics reports to prompt users to drive either an aggregated measure or calculated item. This example will allow your users to dynamically select which measures they want to see in their visualizations.

parameters to pick your metric in Visual Analytics Reports1


  1. Create the custom category to drive the button bar
  2. Create the parameter to hold the button bar’s selection
  3. Create the calculated data item that will hold the selected measure’s value
  4. Add report objects and assign roles

Read More »

Post a Comment

Data is the new soil; get your hands dirty

SAS Global ForumWhen was the last time an informational graph or chart caught your eye? I mean, really caught your eye in a way that made you want to emblazon it on a greeting card or frame it for your office?

What’s that…never?

Me neither, until I had the opportunity to see some of the striking visuals and graphics by David McCandless and hear about the thought and passion that goes into his work as a data journalist. McCandless, the author of Knowledge is Beautiful, was a keynote speaker at SAS® Global Forum April 21, an event traditionally focused on the more technical and logistical aspects of analyzing data.

I’m not exaggerating when I say that I was moved by the informative digital images displayed across the conference venue jumbo screens the way some might be moved by a famous painting or sculpture. They revealed depth of understanding and presented analytical findings in such unexpected ways through story, shape, color and connection.

They were beautiful, indeed. But McCandless was quick to point out that it’s important that data visualization transcends aesthetic beauty and aids comprehension

That’s important when you’re faced with billions of numbers and facts. “Images allow us to see something important in a sea of data,” he said. “They tell a story.”

Read More »

Post a Comment

Solutions for missing DATA step features within DS2

ProblemSolversThe DS2 programming language gives you the following powerful capabilities:

  • The precision that results from using the new supported data types
  • Access to the new expressions, write methods, and packages available in the DS2 syntax
  • Ability to execute SAS Federated Query Language (FedSQL) from within the DS2 program
  • Ability to execute code outside of a SAS session such as on SAS® High-Performance Analytics Server or the SAS® Federation Server
  • Access to the threaded processing in products such as the SAS® In-Database Code Accelerator, SAS High-Performance Analytics Server, and SAS® Enterprise Miner™

Some DATA step functionality is not available in DS2, at least not how you are used to. However, don’t lose hope, because this article discusses ways to mimic some of the missing DATA step features within DS2.

Read More »

Post a Comment

Always be yourself, unless you can be a unicorn

SAS Global ForumWhen you attend SAS® Global Forum - a conference where you’re surrounded by data scientists, programmers and those who grew up as the smartest people in the room – you expect to hear talk about big data and advanced analytics.

What you don’t expect to hear are compelling messages about the importance of art, storytelling…and unicorns.

Advice to data analysts

Emma Warrillow, President of Data Insight Group, Inc., delivering her talk at SAS Global Forum

But Emma Warrillow, President of Data Insight Group, Inc., couldn’t have been more convincing in her April 19 session highlighting the magic formula for becoming a well-sought-after marketing analyst. Her first hint: It requires much more than good programming skills.

She believes in the marriage of art and science. “When you put those two together, that’s where you get the wonder,” she said.

Wonder? Maybe that’s where unicorns come in.

In a sense, perhaps. Actually, unicorns – a rare breed of marketing technologists who understand both marketing and marketing technology (with a nod to John Ellett, contributor to Forbes) – are those who take the time to be curious and recognize that storytelling and imagery are like an analyst’s Trojan horse. Warrillow says they’re the way you get in.

Read More »

Post a Comment

Highlights from SAS Global Forum: Technology Connection

SAS Global ForumEditor's Note: In addition to the summary included in this blog, you can view videos of the following product demonstrations from the Technology Connection at SAS Global Forum 2016 by clicking on the links below:


Executive VP and CTO Armistead Sapp delivers opening remarks at the Technology Connection

“For over 40 years, we’ve seen it, solved it,” said SAS Executive Vice President and Chief Technology Officer Armistead Sapp in his opening remarks at the SAS® Global Forum Technology Connection. If his explanation of SAS differentiators and the road ahead serve as any indication, SAS is just getting started.

So what does set SAS apart? Sapp believes it’s:

  • 40 years of analytics in action.
  • Technology that meets users’ skill sets.
  • Innovation driven by strategy.
  • Analytics that impact the world.

Since last year’s conference alone, he said, a total of 326 products have released, including 88 deployment tools and utilities. That’s a lot of code, but Sapp reiterated that SAS’ first priority to solve for quality, then performance and then new features remains unchanged.

Read More »

Post a Comment

Highlights from SAS Global Forum: Opening Session

SAS Global ForumImpressive innovations and exciting announcements took center stage (literally) at Opening Session of SAS Global Forum 2016. Near the end of the session, SAS CEO Jim Goodnight shared news about SAS’ new architecture that had everyone abuzz.

SAS® Viya™ - There’s a new headliner in Vegas

“We are unveiling a quantum leap forward in making analytics easier to use and accessible to everyone,” Goodnight said. “It’s a major breakthrough and it’s called SAS Viya.”

Goodnight was also quick to point out that SAS Viya will work with customers’ existing SAS 9 software.

Goodnight invited Vice President of Analytic Server Research and Development Oliver Schabenberger, who led the development work for SAS Viya, to join him on stage to discuss the new cloud-based analytic and data management architecture.

Jim Goodnight makes some exciting announcements at SAS Global Forum 2016 Opening Session

Jim Goodnight shares exciting announcements at SAS Global Forum 2016 Opening Session

“We see great diversity in the ways our customers approach and consume analytics,” Schabenberger explained. “From small data to big data. From simple analytics to the toughest machine learning problems. Data in motion and data at rest. Structured and unstructured data. Single users and hundreds of concurrent users. In the cloud and on premises. Data scientists and business users.”

SAS has developed a truly unified and integrated modern environment that everyone can use, whether you are a data scientist or a business analyst. “The beauty of SAS Viya is that it’s unified, open, simple and powerful, and built for the cloud,” said Schabenberger. “Today we are moving to a multi-cloud architecture.”

Goodnight encouraged customers to be “sure to try it out. I think you will enjoy the new SAS Viya.”

Read More »

Post a Comment

Highlights from SAS Global Forum: Cybersecurity, analytic failure and getting arrested

SAS Global ForumEditor's Note: There are hundreds of breakout sessions happening at SAS Global Forum in both the Users and Executive programs. Since we couldn’t just pick one to highlight, we decided to put together a SAS Global Forum day 2 session roundup, highlighting some of our very favorites!

Don’t overlook data management when it comes to cybersecurity analytics

There’s a constant buzz in the market around analytics and its role in the cybersecurity space, but often the conversation overlooks the important role data management plays. Data management is a fundamental component SAS cyber experts want to be sure organizations understand – just because the investment is being made in cyber analytics doesn’t mean companies can ignore data quality and data management.

“There are countless solutions and dollars spent to protect organizations,” said SAS’ Director of Cybersecurity Christopher Smith. “All of those pieces – firewalls, endpoints and email gateways – play a vital role, but those systems don’t communicate with each other.” Even with all the investment organizations are making to protect themselves, there is still no greater insight being gained into what’s actually happening inside company walls.

Read More »

Post a Comment

Highlights from SAS Global Forum: Fantasy football, the data science talent gap and data storytelling

Highlights from SAS Global ForumEditor's Note: There are hundreds of breakout sessions happening at SAS Global Forum in both the Users and Executive programs. Since we couldn’t just pick one to highlight from opening day, we decided to put together a SAS Global Forum day 1 session roundup, highlighting some of our very favorites!

The big data behind fantasy football

With millions of users, peak traffic seasons and thousands of requests a second for complex user-specific data, fantasy football offers many challenges for even the most talented analytical minds. Clint Carpenter, one of the principal architects of the NFL fantasy football program, shared strategies and lessons learned behind football fanatics’ favorite application.

Fantasy football combines a high volume of users with detailed personalized data; multiple data sources; various data consumers; and high peak volumes of request. The challenge is to process the data from the stadium playing field and user devices, and make it easily accessible to a variety of different services. If there’s something to learn from developing and analyzing fantasy football over the years, Carpenter said it’s these three things: don’t blindly trust data or specifications; spend time planning upfront to avoid problems in the end; and test for data integrity, performance and for the whole system. “If you test well, you will have happy stakeholders,” said Carpenter. “If you don’t, you are asking for unhappy users and sleepless nights.”

More from this presentation.

Read More »

Post a Comment

Accessing SPD Engine Data using Hive

Copy Data to Hadoop using SASWith the release of SAS® 9.4 M3, you can now access SAS Scalable Performance Data Engine (SPD Engine) data using Hive. SAS provides a custom Hive SerDe for reading SAS SPD Engine data stored on HDFS, enabling users to access the SPD Engine table from other applications.

The SPD Engine Hive SerDe is delivered in the form of two JAR files. Users need to deploy the SerDe JAR files under “../hadoop-mapreduce/lib” and “../hive/lib” on all nodes of a Hadoop cluster to enable the environment. To access the SPD Engine table from Hive, you need to register the SPD Engine table under Hive metadata using the metastore registration utility provided by SAS.

The Hive SerDe is read-only and cannot serialize data for storage in HDFS. The Hive SerDe does not support creating, altering, or updating SPD Engine data in HDFS using HiveQL or other languages. For those functions, you would use the SPD Engine with SAS applications.


Before you can access an SPD Engine table using Hive SerDe you have to perform the following:

  • Deploy the SAS Foundation software using SAS Deployment Wizard.
  • Select the product name “SAS Hive SerDe for SPDE Data”

Read More »

Post a Comment