Most SAS users know how to sort data with PROC SORT. Fewer users know how this sorting affects the meta data that contains sorting information on the data set. In this post I will introduce two very important pieces of meta data information. The SORTED and VALIDATED...
In many data heavy SAS operations it is crucial to reduce I/O operations. I/O is the most common bottleneck in production ETLs. Therefore, you should think about where your data reside. If you have reasonably sized data sets in a library you access frequently, you...
In my blog post What SAS Books Are On My Shelf, I present the SAS books that I have accumulated over time and my thoughts on them. Since then, three new additions have made their way on to my shelf. Three books on three very different subjects. In this post, I present...
SAS programmers are often interested in the time it takes for their program to run. The common way to measure performance is to simply run code, look in the log, and manually write down the performance statistic of interest. The LOGPARSE Macro is an attempt by SAS...