All Posts
Have you ever heard the expression, “Guess I gotta pay the piper.”? It is often used about a situation where a price is paid that is considered too high or unfair, but failing to pay the price often results in dire consequences. This expression is based on the story of
I guess most of us have a morbid curiosity about how we're going to die ... which is probably why Francis Boscoe's Causes of Death map went viral (no pun intended, of course!). This blog post shows how to create such a map... But first, to lighten up the mood a bit
I recently taught a SAS training course where the students were very engaged. They had so many questions, I could have spent the next month writing helpful blog posts that came from that one class. However, I picked this one question that the class begged for me to share. The
You might have lots of data on lots of customers, but imagine if you could suddenly add in a huge dollop of new, highly informative data that you weren’t able to access before. You could then use analytics to extract some really important insights about these customers, allowing you to
A SAS programmer asked for a list of SAS/IML functions that operate on the columns of an n x p matrix and return a 1 x p row vector of results. The functions that behave this way tend to compute univariate descriptive statistics such as the mean, median, standard deviation, and quantiles. The following
This month we take a fresh analytical view of our hypothetical VirtualOil portfolio by comparing the forward price of WTI (the green line) to the prompt month price (red line). The resulting graphic (chart 1) demonstrates the relative stability of the 48-month forward price in contrast to a very active spot
SAS offers a rich collection of features for working with Hadoop quickly and efficiently. This post will provide a brief run-through of the various technologies used by SAS to get to data in Hadoop and what’s needed to get the job done. Working with text files Base SAS software has the
A recent news report shows an unexpected spike in traffic fatalities here in the US in 2015. This got me wondering what the data shows ... for the past 100 years or so... Driving was a lot more dangerous in the early days. If you were in a wreck, you
I was at a family gathering recently. An elderly relative asked my teenage nephew, "So, what do you want to be when you grow up?" My nephew looked over at me hoping I'd rescue him from the situation. I didn't. But I also recognized the pressure a teen can feel
SAS software is used around the world in some of the most sophisticated ways, like ATM fraud detection and cancer research. But recently, I used it for a practical, and much needed, task -- replacing our break room coffee machine. Now, this is no ordinary coffee machine. It also makes
I previously wrote about the best way to suppress output from SAS procedures. Suppressing output is necessary in simulation and bootstrap analyses, and it is useful in other contexts as well. In my previous article, I wrote, "many programmers use ODS _ALL_ CLOSE as a way to suppress output, but
The final figures are in! This year there was a fierce battle for the top spot of the SAS Global Forum 2015 books bestseller list. In a nail biting finish, newcomer, Exchanging Data between SAS and Microsoft Excel: Tips and Techniques to Transfer and Manage Data More Efficiently, beat off
“Phew! That tip alone was a life saver,” said a student in one of my SAS SQL classes. “Before, I would have to read about ten Google search results before I could find that content of the sort you shared in class.” That student was referring to the tip I
In my last post, we examined the growing importance of event stream processing to predictive and prescriptive analytics. In the example we discussed, we looked at how all the event streams from point-of-sale systems from multiple retail locations are absorbed at a centralized point for analysis. Yet the beneficiaries of those
French fries, pommes frites, chips…or just fries…are indisputably one of the most popular foods in America with the average American consuming nearly 29 pounds of fries a year.