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 …
Tag: sas programming 1: essentials
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, …
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,…
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 abov…
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. (F…
A new year’s resolution that sounds like more fun than a spinning class
Last December I taught a SAS Programming 1: Essentials class at Statistics Canada (Statcan). My class could barely contain their mirth while I valiantly struggled to find the semicolon on the French keyboard. Far cry from my first move to Canada (…