Getting things in order with PROC SQL, macro and a SAS function

Order must be the most frequent cry for help in the SAS classroom. “HELP,” said my student in the classroom. “I work with messy health data. My users want to see data in this order.” T1.col1, t1.col2, t1.col3, t1.col4, t2.col5, t1.col6 and list the remaining columns in column position from […]

Post a Comment

Real-world analytics for Analytics 2013!

You might have seen my previous blog, where I plotted some interesting tourist attractions on a geographical map of the British Isles (which may be of interest to Analytics 2013 Conference delegates)... Well this blog uses even more powerful analytics, and shows how SAS can calculate the "optimal tour" to visit all […]

Post a Comment

Go home on time with these 5 PROC SQL tips

How can you go home on time? Take a quick tour with these 5 tips that I was able to summarize for my students in the SAS SQL 1: Essentials class yesterday. Since they found it handy and asked if it could become a blog post, I thought I’d share […]

Post a Comment

Jedi SAS Tricks: Some Experience Required

As a Master Chief in US Navy submarines, one of my favorite sayings was “Good judgment comes from experience, and experience comes from poor judgment.”  I've always had difficulty solidly learning new programming techniques in a traditional classroom.  The new techniques and theories I've learned don’t really take root until I've used them to solve […]

Post a Comment

Few of my favourite things - SAS informats

Australian merino wool sweaters, Russian watches, Swiss chocolate, Chinese silk blouses, Canadian country music, American sweatshirts, English knitting patterns, Californian pistachios, French muesli, Egyptian bracelets, Scottish kilts, the list goes on. Was I born in a king’s family? Not really, much as I’d like to think of my dad as […]

Post a Comment

Five reasons to use the SAS DATA Step or PROC SQL

When I joined SAS Institute I had no knowledge of SAS. I studied, researched and practiced. The questions I asked would make even the most seasoned programmer blush a beetroot red! Those were an intense nine months—I’ll tell you more in a later post about the learning system at SAS […]

Post a Comment