Throughout my long career of building and implementing data quality processes, I've consistently been told that data quality could not be implemented within data sources, because doing so would disrupt production systems. Therefore, source data was often copied to a central location – a staging area – where it was cleansed, transformed, unduplicated, restructured
SAS will have a major presence at the 2016 INFORMS Conference on Business Analytics and Operations Research, which will be held at the Hyatt Regency Grand Cypress hotel in Orlando, FL on April 10-12. Many SAS staff will participate in this conference. SAS/OR, the SAS Global Academic Program, and JMP
Recently a user was working with the HBAR statement with cluster groups with SG procedures. User wanted to see the group values on the axis. SGPLOT does not display multi level axes as these are shared with different plot types. However, with SGPLOT, there is often a way to get
Tax fraud doesn’t just steal money from taxpayers, it can strip people of their livelihoods and reputations. When a manager in a tax agency’s property tax division stole nearly $50M in property tax refunds, the media and external auditors asked: “How did no one notice this?” The woman started small,
If you happen to be a SAS credential holder, like most candidates, you have invested a lot of time and effort in earning your SAS certification. Wouldn’t it be great if you could broadcast and manage verifiable proof of your achievement where you want and when you want? That’s where
How do universities predict which students will enroll? And how do they determine what actions recruitment officers should take to entice students to pick their university? These were two of the key questions tackled by Lisa Moore, Data Scientist at University of Oklahoma, during her presentation at The Texas Association
Sitting tall on the floor, I close my eyes. I begin to hear sounds in the distance. What is it? It seems close and yet there was a distant echo. The echo drifts into quiet silence. The clock ticks and I think of the faded noise. Could it have been
A soccer fairy tale Imagine it's Soccer Saturday. You've got 10 kids and 10 loads of laundry – along with buried soccer jerseys – that you need to clean before the games begin. Oh, and you have two hours to do this. Fear not! You are a member of an advanced HOA
When you’re making a report, how do you choose which procedure to use? The answer is – it depends. It depends on: whether you are doing an ad hoc analysis or creating a final report that many people will see whether you will run statistical tests with your data or
I know what you're thinking: two "Boaty McBoatface" articles within two weeks? And we're past April Fool's Day? But since I posted my original analysis about the "Name our ship" phenomenon that's happening in the UK right now, a new contender has appeared: Poppy-Mai. The cause of Poppy-Mai, a critically
As I explained in Part 1 of this series, spelling my name wrong does bother me! However, life changes quickly at health insurance, healthcare and pharmaceutical companies. That said, taking unintegrated or cleansed data and propagating it to Hadoop may only help one issue. That would be the issue of getting the data
For thousands of years, the human experience has been recorded by storytellers. Stories tell the tale of our lives: beginning, middle and end. Stories document the triumphs and tragedies of heroes and villains and everything in between. Human beings are storytellers -- it's a trait as uniquely human as an
One of the hidden gems of SAS Studio is the ability to run process flows in parallel. This feature really shines when used in a grid environment. Let’s discuss this one step at a time. First, what is a process flow? When working in the Visual Programmer perspective, you have
The other day I was listening to a Hidden Brain clip about reference bias. Apparently, a new research study found that students exposed to their very best peers became discouraged about their own abilities and performance — and were more likely to drop out. Just on face value, that rang
With the recent changes to federal education policy, I wanted to learn more so I interviewed Emily Baranello, Vice President SAS Education Practice and Susan Gates, SAS Special Advisor on Education. In part 1 of the interview, they were helpful in explaining the new policies, impact, opportunities and challenges for
While you're at SAS Global Forum (or any conference) in Las Vegas, you might have a bit of spare time to do some sightseeing. Therefore I've put together a list & map of interesting things you might want to experience! Below is a snapshot of my map - click it
"I've seen the future of data science, and it is filled with estrogen!" This was the opening remark at a recent talk I heard. If only I'd seen that vision of the future when I was in college. You see, I’ve always loved math (and still do). My first calculus
Most regular readers may have already noticed the release of my new book "Clinical Graphs using SAS", as indicated by the icon of the book cover and the link to the SAS Press page under the "About this blog" section on the right. This book is a result of the various
I've got scale on my mind! While speeding down the rails from Brussels to Paris on the TGV (the sleek, high-speed train), the scale of speed is breathtaking. In previous generations, going from Brussels to Paris for a single-day meeting would have inevitably involved a plane, with check-ins, security, travel
With tax week quickly approaching, tax agencies have been issuing press releases alerting the public they’re holding tax refunds for review longer than in years past. This is a departure for tax agencies. Tax agencies have traditionally lived and died by refund cycle time. Refund cycle time, or getting refunds
While it’s obvious that chickens hatch from eggs that were laid by other chickens, what’s less obvious is which came first – the chicken or the egg? This classic conundrum has long puzzled non-scientists and scientists alike. There are almost as many people on Team Chicken as there are on Team
In the past, configuring a new autoload library for SAS Visual Analytics was a manual process involving steps to create very specific folder structures and to copy and edit scripts and SAS programs. No more! Updates to the SAS Deployment Manager have added a new task that creates and configures new autoload libraries
April 1st is known as April Fools’ Day. We could have chosen to celebrate a number of events that happened on this date. In the U.S. alone, it could have been the creation of the “$” symbol (1778), the marketing of the first dishwashing machine (1889), the first U.S. national
I've worked at SAS for quite awhile, and people always want to know more about SAS, especially it's great work environment. In response to those questions, I've written this story full of SAS product and programming puns to describe how SAS has evolved over time and remains LASR focused on helping
The journey continues as we hear from the instructors for each of the courses being offered on Thursday and Friday, April 21 and 22 after SAS Global Forum. Next up is Mark Jordan who developed and will teach the Introduction to DS2 and Hadoop course. Why should people get excited
.@philsimon on the specific risks to data quality posed by cloud computing.
Mix up your strength training routine with the RFC's Workout of the Month! April's featured equipment is Resistance Tubing - a great option for both in the gym and "on-the-road" workouts.
How comfortable are you with hard decisions? If it affected you, how comfortable would you be with losing your agency and having someone else make the decision for you? What if that decision isn’t made by a person but a machine? More than abstract questions, these are going to become
I have written a new book: Basic ODS Graphics Examples. It is available as a free PDF file on the web. It is in color, and all of the SAS code is available by double clicking a link at the beginning of each example. This new book complements my other
I recently read the book "Die Zahl die aus der Kälte kam" (which would be The Number That Came in from the Cold in English) written by the Austrian mathematician Rudolf Taschner. He is ingenious at presenting complex mathematical relationships to a broader audience. One of his examples deals with
