Of course you know how to create graphs ... But do you often find that preparing the data to plot is often the hardest part? Well then, this blog post is for you! I'll be demonstrating how to import Excel data into SAS, transpose the data, use what were formerly column
"Code golf" is a fun programming pastime that challenges you to solve a problem with the least amount of code possible. Like regular golf, the goal is to use fewest code "strokes" to hit the mark. Here's a recent challenge that was posted to me via Twitter. @cjdinger @SASJedi got
Joyce Norris-Montanari shares tips to help those who are still working to address GDPR requirements.
Which character variables have the highest frequency count? You can easily determine this using a variety of procedures that calculate frequency count. For example, the FREQ Procedure or the MEANS Procedure. This blog post illustrates this process through two examples.
See how to sample unstructured (text) data using SAS Viya and CAS actions. This post includes complete code to cluster the text documents via k-means, and treats the cluster memberships as strata for analysis.
This article shows how to implement balanced bootstrap sampling in SAS. The basic bootstrap samples with replacement from the original data (N observations) to obtain B new samples. This is called "uniform" resampling because each observation has a uniform probability of 1/N of being selected at each step of the
SAS batch jobs can generate many log files that accumulate over time. In this post, we present a SAS program that cleans up old log files on your system.
The Base SAS DATA step has been a powerful tool for many years for SAS programmers. But as data sets grow and programmers work with massively parallel processing (MPP) computing environments such as Teradata, Hadoop or the SAS High-Performance Analytics grid, the data step remains stubbornly single-threaded. Welcome DS2 –
Like hiking without GPS directions, Jim Harris says businesses that don't use streaming data analytics will be lost in a crowd of competitors.
What’s the key to progressing your career? If you ask Manish Desai, a Sr. Director of Consulting, SAS Asia Pacific, based in India, it’s conquering the fear of failure and embracing opportunity – with a great mentor by your side. I sat down with Manish to hear more about his
My colleague Robert Allison recently blogged about using the diameter of Texas as a unit of measurement. The largest distance across Texas is about 801 miles, so Robert wanted to find the set of all points such that the distance from the point to Texas is less than or equal
You can use PROC SGPLOT, BY variables, and a SG annotation data set together to put separate annotations into each BY group. However, you need two more steps to make it happen. This post shows all of the steps necessary to put different annotations into each graph when you have a BY variable.
One of the biggest challenges we’ve been hearing from customers lately is that they need help operationalizing analytics to extend the value of their modeling efforts. In many cases, they’ve hired smart data analysts who can transform data and create sophisticated models, but their work is used for a single
The United States declared independence in 1776, and we celebrate it on July 4th every year. But the land areas that make up the United States today weren't necessarily the same as they were back then. So I thought it would be interesting to create a map showing when each
Word Mover's Distance (WMD) is a distance metric used to measure the dissimilarity between two documents, and its application in text analytics was introduced by a research group from Washington University in 2015. The group's paper, From Word Embeddings To Document Distances, was published on the 32nd International Conference on Machine
SAS works with utilities all over the world, helping these companies capitalize on the value of analytics and become "digital utilities." When we talk to utilities, we look at analytics use cases across: assets and operations; customers; portfolio; and corporate operations (see diagram below). In this fourth post of my four-part
This is my grandson, Easton. He won the lottery by being the first-born grandchild on both sides of our families. We won the lottery when he entered our lives! Putting it mildly, he has an abundance of love in his life. In my eyes, he hung the moon! At one
In a previous article, I showed how to find the intersection (if it exists) between two line segments in the plane. There are some fun problems in probability theory that involve intersections of line segments. One is "What is the probability that two randomly chosen chords of a circle intersect?"
David Loshin provides an alternate take on streaming data in the context of legacy systems.
Did you know that 80 percent of an analytics life cycle is time spent on data preparation? For many SAS users and administrators, data preparation is what you live and breathe day in and day out. Your analysis is only as good as your data, and that's why we wanted
Like the fabled winds of song, new students come sweepin’ down the plains to the University of Oklahoma, with a little help from analytics. I recently had the opportunity to chat with Lisa Moore, Data Scientist at the University of Oklahoma, on her expanding use of predictive analytics. It had
Back in high school, you probably learned to find the intersection of two lines in the plane. The intersection requires solving a system of two linear equations. There are three cases: (1) the lines intersect in a unique point, (2) the lines are parallel and do not intersect, or (3)
Are you still learning about artificial intelligence (AI) and researching how it can be applied to your business scenarios? In a recent Harvard Business Review webinar, Editor of Special Projects & Research at HBR, Angelia Herrin, had an opportunity to discuss the value of AI to organizations with both Michael
SAS programmers have long wanted the ability to control the flow of their SAS programs without having to resort to complex SAS macro programming. With SAS 9.4 Maintenance 5, it's now supported! You can now use %IF-%THEN-%ELSE constructs in open code. This is big news -- even if it only
SAS Visual Text Analytics provides dictionary-based and non-domain-specific tokenization functionality for Chinese documents, however sometimes you still want to get N-gram tokens. This can be especially helpful when the documents are domain-specific and most of the tokens are not included into the SAS-provided Chinese dictionary. What is an N-gram? An
Our company talks to utilities all over the world about the value of analytics and "the digital utility," and we share analytics use cases across: assets and operations; customers; portfolio; and corporate operations (see diagram below). In this third post of my four-part series, I'll highlight a customer analytics use case. Customer
Did you know that SAS has two on-site solar farms? At a combined 2.3 MW in capacity, SAS’ solar farms are located on 12 acres at world headquarters in Cary, NC. The photovoltaic (PV) solar arrays generate 3.8 million kilowatt-hours of clean, renewable energy each year, reducing carbon dioxide emissions
SAS enables you to evaluate a regression model at any location within the range of the data. However, sometimes you might be interested in how the predicted response is increasing or decreasing at specified locations. You can use finite differences to compute the slope (first derivative) of a regression model.
O mundo interconectado. Um mundo inteligente. Onde as empresas/marcas têm acesso a dados que permitem oferecer, aos clientes, soluções/produtos personalizados. Bem-vindos ao mundo (utópico?) da Internet das Coisas. Mas será que esta visão é viável? Como é que as empresas conseguirão atingir este cenário? Falámos com um dos especialistas na
In FiveThirtyEight's Significant Digits section, they recently mentioned that nine states could potentially have 50% or more females in their legislature after the upcoming election. My first thought - I need to see some graphs! They linked to a New York Times article that had some interesting graphs. There was
