SAS 9.3 macro SQL trick

Suppose you need to create a numbered series of macro variables, one macro variable per row, from an SQL query. Suppose you magically know in advance that a given WHERE clause returns, say, 123 rows.  No problem! proc sql; select customer_name into :name1-:name123 from orion.customer where country='DE'; quit; Now suppose you […]

Post a Comment

Jedi SAS Tricks: Building a Name Suffix variable list

If you’ve taken one of my SAS classes you may recall “Mark’s 3 rules of programming”, the first of which is “Lazy programmers are GOOD programmers.”  One of the things I love about best about SAS programming is the plethora of functions and shortcuts built into the language, all designed […]

Post a Comment

2 Popular SAS Topics, 2 Awesome SAS Instructors, a Pinnacle SAS Event

SAS Global Forum creates a big buzz in the SAS user community, so in order to find out what the fuss is about, I decided to chat with a couple of our instructors who would be going to Las Vegas. In addition to teaching pre-conference training, these two instructors will […]

Post a Comment