Tag: Helpful Tricks

Variable Names into Macro Variables

Late last month, I posted an answer to a question on StackOverflow. This morning, I had to use something similar at work and it reminded me that ability to pull variable names out of a data set is a handy trick. For the example, I’m using the yr1001 data set from sashelp to avoid sending […]

Scheduling Jobs

We’ve been on overload the last week with urgent requests as the big yearly meeting looms in the not so distant future. Unfortunately, this means that every single employee is frantically pulling data and hammering the db2 server with requests. I’ve been working around the noticeable slowness by either shortening my date ranges but I […]