Life saver tip for comparing PROC SQL join with SAS data step merge

“Phew! That tip alone was a life saver,” said a student in one of my SAS SQL classes. “Before, I would have to read about ten Google search results before I could find that content of the sort you shared in class.” That student was referring to the tip I […]

Post a Comment

10 reasons to learn SAS code even when you have Enterprise Guide

New York City Mayor, Michael Bloomberg made a new-year's resolution to learn code. Apple’s Steve Jobs said, “I think everybody in this country should learn how to program a computer because it teaches you how to think.” President Barrack Obama said, "Don't just buy a new video game, make one. […]

Post a Comment

Jedi SAS Tricks: Warp Speed DATA Steps with DS2

I remember the first time I was faced with the challenge of parallelizing a DATA step process. It was 2001 and SAS V8.1 was shiny and new. We were processing very large data sets, and the computations performed on each record were quite complex. The processing was crawling along on […]

Post a Comment

I can see clearly now thanks to this SAS student

With any software program, there are always new tips and tricks to learn, and nobody can know them all. Sometimes I even pick up tips or techniques from my students while they’re learning broader programming tips from me. Like fine wine, instructors only get better with age. Every customer interaction […]

Post a Comment

How to eliminate data error notes from the SAS log

A student in a SAS class recently asked if there were a way to eliminate data error notes from the SAS log and, instead, write them to a separate file.  Of course there's a way! Here's a simple datastep.  Notice the missing dollar sign to indicate the variable GENDER (M, […]

Post a Comment

Jedi SAS Tricks - These aren't the labels...

In the first Star Wars movie, Obi-wan uses Jedi mind tricks to convince the stormtroopers that the droids they see are not the droids they're looking for.  A colleague at SAS passed along a question from a SAS user where the column labels they were seeing were NOT the labels […]

Post a Comment

SAS Programming is going on tour

One of my favorite bands, Kings of Leon, is touring again this year and making a stop in Raleigh. I didn’t want to take any chances that I might miss them playing in my hometown so I bought tickets as soon as they went on sale. As you might agree, […]

Post a Comment

SAS Training: Show up and learn

Fear was written large on the faces of my class as I walked in to set up my SAS Enterprise Guide (EG) course. Participants talked in hushed tones and I wondered what this was all about. I was soon to find out during the introductions. Here are some snippets from […]

Post a Comment

SAS tutorial: Create simple scatter plots with two variables using SAS

This SAS tutorial video will show you how to generate plots for two continuous numeric variables with Base SAS. Basic scatter plots, linear or curvilinear regression lines, confidence intervals or ellipses, and multiple plot overlays are demonstrated. To learn more about this topic, check out our SAS Programming 1: Essentials […]

Post a Comment

SAS tutorial: Print a simple listing with SAS

In this tutorial video, you will learn to print a simple listing with Base SAS. You see how to write a PRINT procedure step to display a SAS data set. You also see how to use statements and options to subset observations and variables and enhance the report.   Learn […]

Post a Comment