Friday's Innovation Inspiration - That's a COPY

Diane Olson, from SAS, wrote a SAS Global Forum paper in 2011 that seems ready-made for this SAS user's Post-It note. Olson wrote about PROC COPY and PROC APPEND. In her paper, she lets you in on the inside tricks on how to clone your data set to the same library, copy […]

Post a Comment

Two MWSUG papers in review

Every fall (fall in the US, that is), I try to attend as many SAS Users Groups events as humanly possible. This year, I’m starting with the MidWest SAS Users Groups conference in Minneapolis, then SouthEast SAS Users Group conference in Durham, NC (my home base) and finishing the season […]

Post a Comment

How to mimic the N function for character variables using Data Step, PROC SQL

Many of you know Mike Zdeb. He's a long-time SAS user and frequent presenter at SAS conferences. Zdeb is also a reviewer of many SAS Press books and author of his own SAS book, Maps Made Easy Using SAS. Zdeb contacted me after he read the May SAS Tech Report […]

Post a Comment

Something for nothing? Adding group descriptive statistics

Can you actually get something for nothing?  With PROC SQL’s subquery and remerging features, yes, you can. Often there is a need to add group descriptive statistics such as group counts, minimum and maximum values for further by-group processing.  Instead of first creating the group count, minimum or maximum values […]

Post a Comment

Selecting all observations when any observation is of interest

Now, we all know by now that I'm not a programmer (that makes me very sad sometimes and may frustrate some of you at times), but I know a good paper and presentation when I see one. Christopher Bost knows how to teach a topic. I went to his Tuesday […]

Post a Comment

Delta Air Lines uses SAS to prepare for an emergency

Disasters happen every day. Often times they occur at inconvenient hours and in remote locations. So it’s important to have a plan - before the emergency - to get qualified personnel to those locations in the most efficient way. Pilots are an example of qualified personnel who could act as […]

Post a Comment

SAS users collaborating, improving SAS®

As many of you know, I'm also the Editor of the SAS Tech Report.  For those who don't know what that is, the  SAS Tech Report is a free newsletter published once a month and sent straight to your email inbox. I gather SAS papers, tips and practical information about […]

Post a Comment

Seven steps for avoiding (data) hangovers

In a production environment, where dozens of SAS programs are run in sequence, often monthly or quarterly, and where logs can span thousands of lines, it’s easy to overlook the small stuff that can cause data hangovers.  Recognize any of these? A temporary data set finds its way into subsequent […]

Post a Comment

Five easy steps to write your presentation in SAS®

Most SUG presentations are written in PowerPoint – they may even be written in Word first, and then fancied up a bit in PowerPoint – but they are rarely written in SAS. But Louise Hadden, from Abt Associates Inc, had a need to produce a lot of PDF presentations. She […]

Post a Comment

Running SAS PROCs on your Facebook friends

Contributed by Kirsten Hamstra, SAS Social Media Manager Prolific blogger and author of SAS for Dummies Chris Hemedinger knows maybe a little too much about his Facebook friends. Presenting his paper titled “Social Networking and SAS: Running PROCs on your Facebook Friends,” Chris shared basic techniques to analyze your friends […]

Post a Comment