SAS Users

Programming Tips

Strengthen your programming skills with tips and techniques from the experts

Programming Tips

Waynette TubbsJune 26, 2012 4

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

English

Programming Tips

Sunil GuptaJune 20, 2012 9

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

English

Programming Tips

Kathryn McLawhornMay 30, 2012 6

Concatenation with speed and style

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

English

Programming Tips | SAS Events

Waynette TubbsApril 30, 2012 0

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

English

Programming Tips | SAS Events

Anna BrownApril 25, 2012 0

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

English

Programming Tips | SAS Events

Waynette TubbsApril 24, 2012 0

Macro for collecting, analyzing and reporting on clickstream data

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

English

Programming Tips | SAS Events

Anne-Lindsay BeallNovember 7, 2011 1

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

English

Programming Tips | SAS Events

Anne-Lindsay BeallOctober 25, 2011 0

SAS Data Step Debugger: Your liberator from logic errors

“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.

English

Programming Tips

Waynette TubbsOctober 3, 2011 2

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

English

Programming Tips

Waynette TubbsSeptember 15, 2011 0

Seven truths about metadata

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

English

Blogs

Blogs

Programming Tips