Writing my previous post about digital banks got me thinking about the widespread use of analytics. In his book Digital Bank, Chris Skinner states that data should be seen as the most critical asset for digital banks. Actually, this holds true for almost every company nowadays. If you don’t have data of
With the growing popularity and availability of online reviews and ratings, consumers have more information than ever before when purchasing a hotel stay. In order to build effective pricing and positioning strategies, hotel managers need to understand how consumers are using all of this user generated content with price to
While I was working on my recent blog post about two-dimensional binning, a colleague asked whether I would be discussing "the new hexagonal binning method that was added to the SURVEYREG procedure in SAS/STAT 13.2." I was intrigued: I was not aware that hexagonal binning had been added to a
At the KDD conference this week I heard a great invited presentation called How to Create a $1 billion Model in 20 days: Predictive Modeling in the Real World – A Sprint Case Study. It was presented by Tracey de Poalo from Sprint and former Kaggle President and well known
The ODS ExcelXP tagset has served us well over the years. It provides a reliable method to get formatted SAS output into Microsoft Excel workbooks, where the business world seems to like to live. And it's available in Base SAS, which means that you don't need SAS/ACCESS to PC Files
➤ DISCLOSURE! In June 2018 Google introduced changes to the way it handles its Maps platform. They now require API key in order to embed a map, plus Google Maps "projects" must now be associated with a billing account. Unless these new Google rules are met, Google maps described in
For far too long we have been using the venerable Scatter Plot to do the work of placing text strings in the graph. For far too long we have used the Scatter Plot or the Block Plot to place axis aligned text in the graphs. It is time to
A while back The Wall Street Journal published the article “Corporate Economists Are Hot Again“ that chronicles the resurgence of in-house economists in corporate America. The role of a corporate economist may bring about visuals of classic economist stereotypes (watch Ben Stein play to this stereotype as a teacher in
It’s back to school time which brings a flurry of emotions – sadness that the precious days of summer are over, joy that order and routine may be restored to your household and relief that you don’t have to figure out where your kids will be next week and beyond.
Last Monday I discussed how to choose the bin width and location for a histogram in SAS. The height of each histogram bar shows the number of observations in each bin. Although my recent article didn't mention it, you can also use the IML procedure to count the number of
When you create a histogram with statistical software, the software uses the data (including the sample size) to automatically choose the width and location of the histogram bins. The resulting histogram is an attempt to balance statistical considerations, such as estimating the underlying density, and "human considerations," such as choosing
SAS 9.4 maintenance release M2 was released early in August. This release contains some exciting new features in GTL and SG Procedures. In this article, I will describe some of the new options added to the existing plot statements. Note, I will use the SG examples here, but these are
Looking forward, ten of my SAS colleagues and I are heading to New York City this weekend for KDD 2014: Data Science for the Social Good, which runs August 24-27. This event’s full name is the 20th Association for Computing Machinery Special Interest Group on Knowledge Discovery and Data Mining,
It's easy to plot events that happened at a certain time, but what about events that extended over a range of dates, such as recessions? ... This blog post teaches you a nice trick to use for that! Let's say you have a plot of the labor force participation rate
Great news. If you’ve been struggling to import a Twitter stream as a data source, SAS Visual Analytics 6.4 has greatly simplified that task as part of this release’s expanded data import functionality. The first time you import tweets, you are directed to the Twitter website to log on to
My wife got one of those electronic activity trackers a few months ago and has been diligently walking every day since then. At the end of the day she sometimes reads off how many steps she walked, as measured by her activity tracker. I am always impressed at how many
Did you hear that Prince William is getting a new job? Next year, he’ll fly emergency helicopters for the East Anglian Air Ambulance. The prince, who’ll donate his salary to charity, called his new gig “one of the finest forms of public service.” The Duke of Cambridge won’t get any
If you read SAS blogs but never click through to the comment sections, you're missing some great information. Need proof? Check out some of these comments from the last few weeks. And then leave one of your own. Kelly McGuire has been studying the effects of negative hotel reviews online.
In a comment on last week’s blog asking SAS administrators: please submit your paper idea for SAS Global Forum 2015, Andrew Howell of ANJ Solutions asked if I had any statistics on which were the most popular SAS administrator papers for last year’s conference. He suggested the following nominations although
In a previous blog post, I showed how to use the graph template language (GTL) in SAS to create heat maps with a continuous color ramp. SAS/IML 13.1 includes the HEATMAPCONT subroutine, which makes it easy to create heat maps with continuous color ramps from SAS/IML matrices. Typical usage includes
If you’re anything like me, you are busy. Busy at work, busy at home, busy on the so-called weekend. It never stops. Even as a fitness professionals, my husband and I are right there with you in the constant struggle to find time to exercise and eat healthfully. Here are
If you're a really big company, with many locations around the country, how do you keep track of all that? ... With a great map, of course! I recently read a CNN article about the Community Health Systems network being hacked - exposing the names, Social Security numbers, physical addresses, birthdays
Often there are questions from users on creating histogram using a Log X axis. One such question came up this weekend, where a user wanted a histogram of her data using log axis. Before we get into her specific case, let us first clarify what we may want to see
Before I started my internship with SAS, my only experience with data or analysis came from an “Introduction to Statistics” course I took freshman year to satisfy my math requirement. If I’d known then that statistics and knowing SAS programming would be the #1 skill for a bigger paycheck, or
Heat maps have many uses. In a previous article, I showed how to use heat maps with a discrete color ramp to visualize matrices that have a small number of unique values, such as certain covariance matrices and sparse matrices. You can also use heat maps with a continuous color
In her article Creating Spaghetti Plots Just got Easy, Lelia McConnell has provided us a glimpse into some new useful features in the SAS 9.4M2 release. The term Spaghetti plots generally refers to cases where time series plots have to be identified by multiple group classifications. The support for the
Are there times when you need to pass special characters to a macro variable but cannot find the right technique to accomplish the task? In this article I’ll discuss the different macro quoting functions and give a simple technique to help you determine which macro quoting function to use. Why
Find out which state you'll live in, if the US state borders are redrawn so we have 50 states with equal population! (Don't worry! - This is just a fun/hypothetical "what if" blog!) To get you in the mood for this topic, here's a picture of one of the many
In my industry of data and computer science, precision is typically regarded as a virtue. The more exact that you can be, the better. Many of my colleagues are passionate about the idea, which isn't surprising for a statistical software company. But in social media, precision is a stigma --
The SAS Global Forum 2015 Call for Papers opened the end of last month! I cannot believe it is time to start getting ready for the conference that will be in Dallas, TX on April 26-29, 2015. As part of the group from SAS who goes to the conference each
