The DATA step remains a popular way to create and manipulate SAS data sets. Whether you are reshaping a data set entirely or simply assigning values to a new variable, there are numerous tips and tricks that you can use to save time and keystrokes.
SAS' Leonid Batkhan shows you how to compare SAS data sets that include common and uncommon columns. You'll learn how to check mark commonalities and color-code differences in data tables side-by-side columns and add a comments field to see greater detail.
Recently I showed how to visualize and analyze longitudinal data in which subjects are measured at multiple time points. A very common situation is that the data are collected at two time points. For example, in medicine it is very common to measure some quantity (blood pressure, cholesterol, white-blood cell
Another year, another traditional Christmas song or carol turned into a fun technology-related version! This is the sixth year and my ninth song. I hope you enjoy your 2019 holiday song, based on this famous tune. The Data Science and AI Song Computer vision processing on an open stack The
One analysis suggests that in the first year of using process mining, the telecoms company had decreased its cost per process order by almost 40% and improved its productivity.
This is a second article about analyzing longitudinal data, which features measurements that are repeatedly taken on subjects at several points in time. The previous article discusses a response-profile analysis, which uses an ANOVA method to determine differences between the means of an experimental group and a placebo group. The
SAS Viya is a cloud-enabled, in-memory analytics engine which allows for rapid analytics insights. Viya utilizes the SAS Cloud Analytics Services (CAS) to perform various actions and tasks. Best of all, CAS is accessible from various interfaces including R. In this blog, I will go through a few blocks one of my notebooks, which moves through an analytics workflow using R and SAS.
If you’re like me, you struggle to buy gifts. Most folks in my inner circle already have everything they need and most of what they want. Most folks, that is, except the tech-lovers. That’s because there’s always something new on the horizon. There’s always a new gadget or program. Or
Site relaunches with improved content, organization and navigation. In 2016, a cross-divisional SAS team created developer.sas.com. Their mission: Build a bridge between SAS (and our software) and open source developers. The initial effort made available basic information about SAS® Viya® and integration with open source technologies. In June 2018, the
If you don't have a SAS/Graph license, then you're probably using the ODS Graphics 'sg' procedures that come with Base SAS to create your graphs and maps. And if you've tried plotting data on a map, you probably noticed that SGmap lets you overlay point-data on an OpenStreetmap, but you
Longitudinal data are used in many health-related studies in which individuals are measured at multiple points in time to monitor changes in a response variable, such as weight, cholesterol, or blood pressure. There are many excellent articles and books that describe the advantages of a mixed model for analyzing longitudinal
In just over six months, football fans across Europe face a logistical maze: how to follow their favourite teams from stadium to stadium as games are played all over the continent. We described the challenge and optimisation approach we took in a separate piece. In this gallery, we walk
Football fans around the world have something exciting to look forward to, with the European Championship scheduled to take place in June and July 2020. Twenty teams out of 24 have already qualified for the tournament, and after last Saturday's draw, the teams and fans are now getting ready to
The Local Government Association has concluded that in the last 10 years, there has been a reduction in funding of 60p for every £1.
With time series data analysis, we can apply moving average methods to predict data points without seasonality. This includes Simple Average (SA), Simple Moving Average (SMA), Weighted Moving Average (WMA), Exponential Moving Average (EMA), etc. For series with a trend but without seasonality, we can use linear, non-linear and autoregressive
This article discusses how to restrict a multivariate function to a linear subspace. This is a useful technique in many situations, including visualizing an objective function that is constrained by linear equalities. For example, the graph to the right is from a previous article about how to evaluate quadratic polynomials.
This year the Hour of Code theme is #CSforgood, with a focus on the United Nations' Sustainable Development Goals (SDGs). We're very excited about this theme because we believe computer science and technology play an important role in solving the world's biggest problems. But the first step in empowering the
If you are a caregiver, the holiday season may bring less Peace and Good Tidings, and more Stress and Frustration. If you are already feeling overwhelmed with caregiving responsibilities, the holidays may feel more of a burden than a joy. I think it is fair to say that the holidays are
North Carolina recently re-drew the congressional district boundaries for the upcoming 2020 election. Here's a copy of the new map, from the ncleg.gov website: A couple of years ago, I created an enhanced version of the 2016/18 map, and I thought I'd do the same for the new 2020 map...
A business glossary improves data quality – one of the top five ways it makes analytics better.
I grew up in Massachusetts. Waking up to a fresh blanket of snow was not unusual on Thanksgiving. I remember the windows on our small, ranch home were often frosty with condensation in the morning. Mom would take a hand towel to wipe them down. The house was heated with
What is an efficient way to evaluate a multivariate quadratic polynomial in p variables? The answer is to use matrix computations! A multivariate quadratic polynomial can be written as the sum of a purely quadratic term (degree 2), a purely linear term (degree 1), and a constant term (degree 0).
“Ocean acidification is sometimes referred to as global warming's equally evil twin.” ~ Elizabeth Kolbert This is the second post in my two-part series about climate change. You can read part 1 of this series here. When engaging in data exploration for insights, it’s good practice to start with a
The English language can be a bit tough to learn. One reason is that sometimes words can have more than one meaning. For example, the word shady can mean "of doubtful honesty or legality," or it can mean "giving shade from sunlight." Which of those meanings am I thinking about,
Although we are still learning about all the negative health impacts on the body, it is important to remember that vaping is dangerous. And it is especially dangerous for our youth as their developing brains are much more susceptible to addiction. There is a lot of misinformation out there so
If you’re like me, you have a random assortment of mason jars around the house in all shapes and sizes. While I use them on a fairly regular basis, some of them are forgotten in the bottom of the cabinet. However, this clever kitchen hack will help you upcycle those
Analytics is a game-changer in detecting procurement fraud. It is by far the most efficient way of doing so.