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
Tag: tips & techniques
I am part of a 'virtual team from SAS Technical Support' who provide the suggestions for the Tips & Techiques section for the SAS Tech Report each month. A couple of days ago, Bill Gibson, Chief Technology Officer from SAS Australia, sent us an email saying that like him, many
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
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
Today, everyone from chief marketing officers to the senior vice president of sales to bloggers want to know more about the behavior of the readers and consumers who are clicking on Web pages, Internet articles and blogs. Clickstream data is a valuable source of information about the products, services and information that resonates with
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
“I really wish someone had shown me this function in SAS sooner, because it’s saved me a ton of time and effort,” said Brandi Rhoads as she opened her presentation at the Western Users of SAS Software (WUSS) conference in San Francisco.
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
Metadata is data about data. For the purposes of his NESUG 2011 presentation, Frank DiIorio defined metadata more precisely as data about data and data that describes workflow objects and processes. DiIorio wrote his paper because organizations are challenged more and more today to do more with less. Metadata can
Kathleen Harkins, Carolyn Maass and Mary Anne Rutkowski, from Merck Sharp and Dohme, collaborated to write T.I.P.S: Techniques and information for programming in SAS® for NESUG 2011. These three women are highly experienced programmers: Harkins has more than 20 years of experience in the pharmaceutical and aerospace industries; Maass has
~Contributed by Philip Busby, Applications Developer at SAS (@Philihp)~ My mind was blown just now at Paul Gorrell's talk on numeric values within SAS. The nice thing that hooks new programmers to SAS is how easy it is to do so many things, but what I find really makes a
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
Jean Balent gave a quick 20-minute presentation of her ideas that may help programmers become more organized and therefore more productive. The presentation is a shortened version of her paper, How to become an organized SAS programmer. In fact, her tips may be useful in other areas of your career.