I can recognize several languages when I hear people speaking them (mostly because I lived in the Alexander International Dorm at NC State University). Therefore when I found a map of the most common languages spoken in each US state, it caught my attention, and I decided to try creating my
Tag: macros
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
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
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