In the blog post Using the BUFSIZE and BUFNO Options in SAS, I demonstrate how to set the size and number of the input/output buffers in memory. Sometimes, we want to load an entire data set into memory. We could use the BUFNO and BUFSIZE system options and set them...
Last week, I wrote about how to Use Arrays To Look Up Data In SAS. There are numerous ways to combine data sets and look up data from multiple sources in SAS. Therefore it is essential to know the different approaches and when to use them. Today, I demonstrate how to...
Do you have those snips of SAS code you run over and over again? I do. However, I do not type the entire thing into my editor anymore (I did that for way too long). Instead, I add abbreviations to my SAS editor. Consequently, I save a lot of unnecessary typing and get...
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...
I prefer the Data Step over PROC SQL. However, some applications are solved with much simpler code in PROC SQL. In those cases, I have to force myself on to the SQL side. Such a situation arises in the blog post Select By Group Conditional On Observation. The Data...
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...