One of my favorite Eddie Murphy movies when I was growing up was Coming to America. And speaking of coming to America, there’s been a lot in the news recently about people doing just that. So I thought I’d use my SAS skills to help people wanting to co…
Tableplots and ACS data
A question recently popped up in a discussion forum about creating table plots using SAS. So I thought I’d dabble in this topic, and see what I could come up with. If you’re interested in tableplots, or American Community Survey (ACS) data, or data vis…
How to use SAS to read a range of cells from Excel
I’ve said it before: spreadsheets are not databases. However, many of us use spreadsheets as if they were databases, and then we struggle when the spreadsheet layout does not support database-style rigor of predictable rows, columns, and variable types — the basic elements we need for analytics and reporting. If […]
The post How to use SAS to read a range of cells from Excel appeared first on The SAS Dummy.
Changing font size in SAS
When making a new piece of code, I like to use the smallest font I can read. This lets me fit more text on the screen at once. When presenting code to others, especially in a classroom setting, I like to make the font large enough to see from the back…
SAS analytics for the Gorge Downwind Champs race
Ever since the Moneyball book & movie came out, athletes have been scrambling to use data and analytics to gain a competitive advantage. One of my favorite sports is boat racing – the ones you paddle. Follow along as I lead you through some maps an…
Cremation rates in the US, by state
I recently read an interesting article that claims “a single cremation emits as much carbon dioxide as a 1,000-mile car trip.” This got me wondering about cremation data, and I ended up on the Wikipedia page about cremation rates. They had a map of the…