Last year, 50 companies came knocking on the doors of Rotman School of Management in Canada to recruit Masters of Business Administration (MBA) grads with SAS skills. This year, Rotman partnered with SAS to offer SAS Programming to interested candidates. Last Sunday, I had the amazing opportunity to teach SAS
Author
A student brought in this coding problem after her manager was struggling with this issue for a while. They played guessing games, but to no avail. Here’s what happened when they submitted data step and proc sql code using a WHERE clause with an INPUT function? data aileen; length hcn
Order must be the most frequent cry for help in the SAS classroom. “HELP,” said my student in the classroom. “I work with messy health data. My users want to see data in this order.” T1.col1, t1.col2, t1.col3, t1.col4, t2.col5, t1.col6 and list the remaining columns in column position from
Fear was written large on the faces of my class as I walked in to set up my SAS Enterprise Guide (EG) course. Participants talked in hushed tones and I wondered what this was all about. I was soon to find out during the introductions. Here are some snippets from
On any given day, on an average, good programmers spend maybe about 10-20% of their time writing code. And the remaining 90% thinking, researching, and experimenting to find the best design. With so much thinking time, they need every bit of help to reduce the amount of typing time. Not-so-good
This robin chick chirped away in my backyard on a glorious summer afternoon. While papa robin hovered above, the chick hopped on ground following Dad. Soon Dad disappeared after leading the chick to a tree where two gray squirrels smacked their lips at the sight of an easy lunch. Lifting
How do you like your sandwich? On rye, whole wheat or white bread? What fillings and dressings do you like? You probably think I’ve gone completely crazy and I don’t blame you. What does food have to do with SAS, you say? Loads -- as you’ll find out with this
Tried, tested and true -- I’m sure you already practice some, if not all, of these efficient techniques to save resources. I recently shared these 10 techniques with the Wisconsin Illinois SAS users group in Milwaukee. The conference ran smoothly under the incredibly able guidance of Dr. LeRoy Bessler. I’ll
San Francisco! The Bay Area and Silicon Valley: innovation, the brightest minds, creating, inspiring new technology and style. This city is known for its healthy food choices. For example, I spotted a homeless man on my way from the Westin St. Francis to the Moscone Conference Center with this never-
To optimize a Structured Query Language (SQL), the database professional must befriend this order and perhaps even embrace it. Who is your best friend? I’m talking about the order in which SQL processes your statements. Simply put, in what order does SQL do your work? (From my previous post you