The SAS Dummy

Programming Tips

Strengthen your programming skills with tips and techniques from the experts

Programming Tips

Chris HemedingerFebruary 4, 2011 0

New Goodies for SAS Programmers: View it now

Millions of Americans will be gathering around the television this Sunday to watch Super Bowl XLV. They'll gather in bars and private homes, prepare billions of calories worth of snacks, and root for their favorite teams. But if you're looking for an alternate form of entertainment, why not watch "New

English

Programming Tips

Chris HemedingerJanuary 19, 2011 4

Who am I to judge?

Tomorrow I'll be taking a few hours away from work to build something important: the self-esteems of a handful of middle-school-aged children. I'm volunteering as a judge in a middle-school science fair. And even though I'm not a scientist ("computer science" isn't a category), I understand enough about physical science

English

Programming Tips

Chris HemedingerJanuary 10, 2011 20

You asked for it: the Autoexec process flow

AUTOEXEC.SAS wasn't enough for you. Yes, it's a sure-fire way to run SAS statements (such as LIBNAME assignments or macro definitions) whenever you start your SAS session, but you found it has limitations when used in configurations with lots of users who connect with SAS Enterprise Guide. Limitations such as:

English

Programming Tips

Chris HemedingerDecember 23, 2010 6

The SAS code formatter: more than a pretty face

A customer phoned up SAS Technical Support the other day with a problem. (Yes, that happens occasionally...) When he ran a certain program through SAS Enterprise Guide, the program didn't seem to complete and no results were returned. Here is a snippet of the program (modified a bit to make

English

Programming Tips

Chris HemedingerDecember 17, 2010 12

SAS logs in Enterprise Guide: Where's the beef?

You might be too young to remember Clara Peller. She was the star of a series of fast-food burger commercials in the 1980s, in which she demanded meatier meals by shouting "Where's the beef?" at the pickup counter or drive-through window. Alas, the competitor restaurant meals were afflicted with "Fluffy

English

Programming Tips

Chris HemedingerDecember 8, 2010 9

In-your-face SETINIT warnings, at a desktop near you

I connect to more SAS server environments than your average SAS user. In a given week, I probably run SAS Enterprise Guide connecting to at least five different Windows-based servers, a few Unix-based servers, and maybe even a z/OS machine as well. With that many SAS environments, I'm bound to

English

Programming Tips

Chris HemedingerNovember 24, 2010 9

Calculating the UTC offset in your SAS session

Update 25Nov2010: I've updated this example to correct the code so that it works correctly for positive UTC offsets. Thanks to Bruno Müller, my colleague at SAS, for finding my mistakes. One of my SAS colleagues was recently working on a project where she had to create reports that include

English

Programming Tips

Chris HemedingerNovember 23, 2010 21

Five strategies to eliminate passwords from your SAS programs

Many people mistakenly assume that just because you want to use a SAS program to access a protected resource (such as a database table), you must include the credentials for the resource inside your program. Few things cause a database administrator to lose more sleep than coming across this within

English

Programming Tips

Chris HemedingerNovember 22, 2010 2

Process Explorer: tools for the SAS admin on Windows

It was over two years ago that I shared the tip of using Process Explorer to look under the covers at which SAS processes were running on your Windows environment. Process Explorer recently received a refresh, and it's worth downloading the new version. (Yes, it's free.) If you want to

English

Programming Tips

Chris HemedingerNovember 16, 2010 4

Look before you buy: peek at your data details before opening

Are you afraid of big commitments? Do you like to shop around thoroughly before making a purchase decision? I can't help you with most of Life's Big Choices, but I can help you in one way: I can show you how to learn more about your data set before you

English

Blogs

Blogs

Programming Tips