SAS tutorial: Import a comma-separated file into SAS

In this tutorial video, you will learn how to read comma-separated-value (CSV) files with Base SAS using a DATA step. This enables you to create a SAS data set copy that transforms each field in the raw data file into a variable in the data set. Watch and learn how... […]

Post a Comment

An easy way to find variables in common to data sets

Over the holidays I was having a discussion with my cat, Ms. Trixie Lou. A question that often arises during the first programming class is the following: how do I find the variables that are in common to these two or three data sets? As it turns out, Ms. Trixie […]

#1 SAS programming tip for 2012

What tiny looking operator packs a mighty punch with large datasets?  Your queries are big. Your reports span multiple columns. To top it all you have to summarize data in multiple ways. Are you tempted to throw in the towel? Do you feel like saying a firm “Can’t be done” […]

Post a Comment

Bad words in SAS - PG rating

Picture this – a student grabs the Programming 1 textbook, scans it quickly seemingly searching for something specific, and shakes his head indicating an unsuccessful search. He plants himself smack dab in the front row, looks me squarely in the eye, raises one eyebrow quizzically and says, “Bad words?” I […]

Post a Comment

SAS Programmer Rule # 1

Let’s start with a quiz. Which of the following is the Programmer’s Rule # 1? 1. Expert knowledge of multiple languages, like SAS and Java 2. Talent to maneuver with complex algorithms 3. Innate ability to draw flowcharts 4. None of the above Dear reader, as a savvy programmer, you […]

Post a Comment

Find your data pattern with Perl

Who doesn’t like bargains? I’m sure you will all agree that good quality at a next-to-nothing cost is irresistible. My recent Dollarama run had me ecstatic about the gloves that come in all colours, styles and sizes for just over a dollar. (Fact: big retail stores charge over 10 times […]

Post a Comment