Three Other PROC SORT Options You Should Know

Three Other PROC SORT Options You Should Know

In the blog post Three PROC SORT Options You Should Know, I demonstrate how to use the three options Sortsize, Tagsort and Presorted. Sorting data is usually the most CPU and time consuming part of a data flow. Therefore, you should familiarize yourself with PROC SORT...
Creating Multilabel Formats in SAS with PROC FORMAT

Creating Multilabel Formats in SAS with PROC FORMAT

Multilabel formats allow programmers to create overlapping classes in SAS. This can be quite handy when the classes are not mutually exclusive. This post demonstrates how to handle such cases with the Multilabel Option in the Format Procedure. In the examples to come,...
AVL Tree Distribution in SAS Hash Objects Explained

AVL Tree Distribution in SAS Hash Objects Explained

When a SAS Hash Object encounters a key value, it runs the value through a Hash Function. The hash function assigns the key value to a bucket called an AVL Tree. This post demonstrates an example of how this distribution takes place and why it plays a crucial role in...
A SAS Hash Object Of Hash Objects (Hash Of Hashes)

A SAS Hash Object Of Hash Objects (Hash Of Hashes)

The SAS hash object is a very flexible data structure. It can contain numeric and character data variables. But did you know that it can contain other hash objects as well? Not many programmers do. This post demonstrates the Hash of Hash method by a few examples....
Load SAS Data Set Into Memory With SASFILE Statement

Load SAS Data Set Into Memory With SASFILE Statement

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...
Advanced Techniques to Reduce SAS Hash Object Size

Advanced Techniques to Reduce SAS Hash Object Size

In the blog post Three Basic Techniques to Reduce SAS Hash Object Size, I demonstrate how we can reduce the memory footprint of a SAS hash object with familiar programming tools. Today, I will show a few more techniques. Though these are a bit more complicated. As in...