HAVING (clause) fun with SAS Enterprise Guide

Chris Hemedinger
Chris Hemedinger|September 18, 2012

Last week I attended a meeting of the Toronto Area SAS Society. (Okay, I didn’t just attend; I was a presenter as well.) This user group meeting contained a feature that I had never seen before: “Solutions to the Posed Problem”. Weeks before the meeting, an “open problem” was posted [...]

Post a Comment

Comparing data set schemas in SAS

Chris Hemedinger
Chris Hemedinger|August 15, 2012

The project that I’m currently working on requires several input data tables, and those tables must have a specific schema. That is, each input table must contain columns of a specific name, type, and length in order for the rest of the system to function correctly. The schema requirements aren’t [...]

Post a Comment

Improving on a SAS programming pattern

Chris Hemedinger
Chris Hemedinger|March 23, 2012

Earlier this week I described a common programming pattern in the SAS macro language. The pattern sets up a loop for processing each distinct value of a classification variable. The program uses the PROC SQL SELECT INTO feature to populate SAS macro variables. The effect: you can roll your own [...]

Post a Comment

What to do IN BETWEEN dates

Chris Hemedinger
Chris Hemedinger|September 29, 2010

I saw a suggestion arrive from a SAS customer who would like to see the IN operator extended to allow ranges of date values. For example, you can currently write a program that checks for values IN a collection or range of numbers: data check; if x in (1:10) then [...]

Post a Comment