Default PROC FREQ output looks like this: Suppose you don’t want the two cumulative statistic columns above. No problem. Those can be suppressed with the NOCUM option on the TABLE statement, like this: proc freq data=sashelp.shoes; table product / nocum; run; Now your output looks like this, but you lose […]
The post Weird PROC FREQ trick appeared first on The SAS Training Post.
A couple of years ago, I blogged about the most popular baby names in the US over the past 100 years. This time, I focus on the most recent year, and take it to the state level! But before we get started, here’s a picture of my friend Jennifer’s daughter, […]
The post What’s the most popular baby name in your state? appeared first on The SAS Training Post.
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 […]
The post Creating a map using death data appeared first on The SAS Training Post.
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 […]
The post Looking for a SAS job? Join the 21-day SAS challenge appeared first on The SAS Training Post.
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 […]
The post Cars versus drivers: Who’s safer? appeared first on The SAS Training Post.
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 […]
The post How analytics saved the break room coffee machine appeared first on The SAS Training Post.
“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 […]
The post Life saver tip for comparing PROC SQL join with SAS data step merge appeared first on The SAS Training Post.
I saw an interesting graph on dadaviz.com that claimed Italians had gone from drinking twice as much as Americans in 1970, to less than Americans in recent years. The data analyst in me just had to “independently verify” this factoid … But before I get into the technical part of this […]
The post Do Italians really drink less alcohol than Americans? appeared first on The SAS Training Post.