This is a continuation of my previous blog post on SAS Data Studio and the Code transform. In this post, I will review some additional examples of using the Code transform in a SAS Data Studio data plan to help you prepare your data for analytic reports and/or models. Create
SAS Data Studio is a new application in SAS Viya 3.3 that provides a mechanism for performing simple, self-service data preparation tasks to prepare data for use in SAS Visual Analytics or other applications. It is accessed via the Prepare Data menu item or tile on SAS Home. Note: A
IBF Free Webinar The Institute of Business Forecasting is offering a free webinar on March 29, 2018: Analytically Speaking: Transforming Forecasting & Demand Planning in a New Era The webinar will be delivered by Chad Schumacher, Senior Director of Global Analytics at Kellogg's, and you can register here. From the
What message do former Google CEO Eric Schmidt, CMS Administrator Seema Verma, and White House Senior Advisor Jared Kushner have in common? They all asserted the importance of person-centered care in their respective remarks at HIMSS two weeks ago in Las Vegas. Person-centered care treats the patient/healthcare consumer as an
Phil Simon chimes in on a way to lock down data
In the medical field, an autopsy is valuable because it helps you understand the cause of death. But, what’s more valuable is identifying the leading indicators of an illness so that you can address it before the Grim Reaper comes knocking. Best in class organizations are taking a similar approach
Waffle irons are just for making waffles, right? WRONG! Obviously, waffle irons do make waffles, but if you’ve only been using it for waffles, you’re missing out.
One of my favorite magazines, Significance, printed an intriguing image of a symmetric matrix that shows repetition in a song's lyrics. The image was created by Colin Morris, who has created many similar images. When I saw these images, I knew that I wanted to duplicate the analysis in SAS!
SAS Visual Analytics 8.2 introduces the Hidden Data Role. This role can accept one or more category or date data items which will be included in the query results but will not be displayed with the object. You can use this Hidden Data Role in: Mapping Data Sources. Color-Mapped Display
My buddy Rick Wicklin recently pointed me towards an animation of some opioid prescription rate data for Illinois. And, of course, I decided we needed a similar animation for North Carolina (with a few improvements...) Here's the original, and here are the problems that jump out at me: Counties with
Welcome to my annual Pi Day post. Every year on March 14th (written 3/14 in the US), geeky mathematicians and their friends celebrate "all things pi-related" because 3.14 is the three-decimal approximation to pi. Pi is a mathematical constant that never changes. Pi is the same value today as it
We have updated our software for improved interpretability since this post was written. For the latest on this topic, read our new series on model-agnostic interpretability. Don`t jump into modelling. First, understand and explore your data! This is common advice for many data scientists. If your data set is messy,
I bet many of you didn’t even know the term machine learning five years ago. But Gartner did. The Gartner Magic Quadrant for Data Science and Machine Learning Platforms, 2018 was just released, and SAS has been in the leader’s quadrant for five years straight. According to Gartner, “This Magic
SAS Viya 3.3 introduced a set of command-line interfaces that SAS Viya administrators will find extremely useful. The command-line interfaces(CLI) will allow administrators to perform numerous administrative tasks in batch as an alternative to using the SAS Environment Manager interface. In addition, calls to the CLI’s can be chained together
Much has been written about the value that North Carolina’s Criminal Justice Law Enforcement Automated Data Services (CJLEADS) system has brought the state’s court personnel and law enforcement officers. CJLEADS integrates dozens of NC criminal justice and law enforcement data sets, a vast improvement over the state’s legacy processes. Law
Data analysts often fit a probability distribution to data. When you have access to the data, a common technique is to use maximum likelihood estimation (MLE) to compute the parameters of a distribution that are "most likely" to have produced the observed data. However, how can you fit a distribution
Have you ever experienced that “gut feeling” ….you know the one that’s trying to tell you something and you don’t know why? I remember having a feeling I couldn’t quite explain fifteen years ago. There was a job opportunity in Canada. As a way to entice moving there, I was provided
The R SWAT package (SAS Wrapper for Analytics Transfer) enables you to upload big data into an in-memory distributed environment to manage data and create predictive models using familiar R syntax. In the SAS Viya Integration with Open Source Languages: R course, you learn the syntax and methodology required to
Are you going to Denver, Colorado, and wondering what fun/interesting/eclectic things you can do there? Then this is the map for you! For the past couple of years, I've made maps of the city SAS Global Forum is in, pointing out some of the attractions that conference attendees might want
The LOESS statement in PROC SGPLOT finds a fit function while making no assumptions about the parametric form of the regression function.
“There’s so much free time on my work calendar this week” said No SAS Employee Ever. For most of us there's never a lot of downtime at work but there are certain times of the year that we consider our ‘busy season’. For Work/Life it’s January, right after the holidays.
Joyce Norris-Montanari starts this two-part series with some suggested actions you can take to help you comply with the GDPR.
Do you procrastinate and find excuses to delay doing certain things, even when you know they really ought to be done? And you probably realize that starting those projects is usually the hardest part, eh? Well, I finally started converting hundreds of my SAS examples to use the new GfK maps,
Many people know that a surface can contain a saddle point, but did you know that you can define the saddle point of a matrix? Saddle points in matrices are somewhat rare, which means that if you choose a random matrix you are unlikely to choose one that has a
This article is motivated by a recent question on the SAS Communities board. This user wants to create a series or spline plot where the attributes of the line (color, thickness) can be changed based on another variable. In this case it may be a binary variable with "0" and
Report data shared by educational institutions, government agencies, healthcare organizations, and human resource departments can contain sensitive or confidential data. Data in such reports are suppressed selectively to protect the identities of individuals or to prevent the report’s audience from easily inferring individual values. The Data Suppression feature in SAS
You’ve probably heard the stats about the number of internet-connected devices, which make up the Internet of Things (IoT). Most likely, you’re part of the narrative. We're all connected in new ways and through more devices than ever before. Sometimes IoT impacts our daily lives – safety sensors on cars,
Let’s say that you are administering a SAS 9.4 environment that is working just fine. You’ve checked that your full backups are indeed happening and you’ve even tried restoring from one of your backups. You are prepared for anything, right? Well, I’d like to propose a scenario to you. You
It’s been quite an interesting Winter, one that was predicted by the Farmer’s Almanac to be cold and wet. Cold? Not so much. Wet? Painfully so! Parts of it have been beautiful, though, including an unexpected snow storm in January that covered our area in 10 – 12 inches of
This article shows how to use SAS to solve a system of nonlinear equations. When there are n unknowns and n equations, this problem is equivalent to finding a multivariate root of a vector-valued function F(x) = 0 because you can always write the system as f1(x1, x2, ..., xn)
