If you're preparing a big Thanksgiving dinner, then you don't want to leave out the most popular side dish, do you?!? But what is the most popular side dish? ... If you don't already know, then perhaps some data & analytics can help! But before we get started, here's a
Here in the US, we're preparing to celebrate the Thanksgiving holiday. Therefore this Thursday most families in the US will be having a big turkey dinner. Although I'm a bachelor guy and eat out all the time, I'm actually a pretty good cook - and I'd like to share with
Information Dashboards were the hot topic a few years ago, but the hype seems to have died down lately. A good dashboard is still a very useful way to summarize, analyze, and share data - so I thought I'd re-visit the topic, and try to improve an old dashboard. Did
Here's a Proc Print trick for grouped data. Suppose your data is divided into groups, such as males and females. You could sort by the grouping variable before printing, like this: Suppose you want to better emphasize the groups. You could add a BY statement, like this: OK, but, personally,
One of the great things about living in an area that has seasons is you get to see the leaves change colors in the fall. If you're a big fan of seeing the leaves at their peak, you could actually travel around the country and see the leaves at their
I recently saw an alarming article on social media about an outbreak of airborne plague spreading from Madagascar to Africa (and potentially to the rest of the world). The plague?!? - I thought that only happened hundreds of years ago?!? I don't really trust news on Facebook, so I went
A ghoulish Halloween Boo to all my readers! Hope my costume freaks you out, but even if it doesn't, I’m positive PROC FREQ will in a few amazing ways! Today’s Programming 2: Data Manipulation Techniques class asked about the power of PROC FREQ. Since I stopped to explain some of it's benefits to
I often create temporary ODS output files - and getting rid of those files after I'm done is an extra chore I don't relish. For example, if I want to generate a PDF-only report and email it from SAS (see "Jedi SAS Tricks: Email from the Front – Part 2")
If you plan to travel abroad and see the world, you'll need a passport. And, depending on several factors, you might also need travel visas. Which passports allow you to travel with the least amount of hassle (and the least amounts of visas)? Let's create a map to help you
Suppose you want a list of car manufacturers from the CARS dataset. Easy! Call the %CHARLIST macro from a %PUT statement, like this: The CHARLIST macro generates a list of unique values of a selected variable from a selected dataset. So does PROC FREQ. But, if you don't need statistics, the CHARLIST
