Top N By Group with Hash of Hashes in SAS
This article demonstrates how to use the hash of hashes technique to create top N lists by group in SAS. No pre sorting needed and memory kept at a minimum.
Use Binary Search of Array in SAS Table Lookup
In the blog post Binary Searching an Array in SAS, we explore how to perform a binary search of a temporary array in SAS. We compare different approaches and learn that the binary search is much faster than a simple sequential search. Today, let us use the binary...
Mean Imputation in SAS Using the Hash Object
This post demonstrates an alternative way to do mean imputation in SAS using the hash object instead of the traditional methods.
Binary Searching an Array in SAS
A binary search of a SAS array does not come out of the box. This post demonstrates how to program the binary search in the SAS data step.
Another Word on Array Hashing in SAS
In this post, we expand the array hashing technique to handle multiple key variables and multiple data variables. And compare to the regular hash object.
Array Hashing With Character Key Values
This post demonstrates how to generalize the temporary array hashing technique from integer numeric values to general character key variables.
How to Reverse Characters in a String in SAS
This post demonstrates how to reverse the characters in a string in SAS. I will primarily use the Reverse Function and Revers Character Format.
Count Distinct Values in SAS With the Hash Object
To count distinct values is usually done in Proc SQL in SAS. We take a different approach and show how to count distinct values with the hash object in SAS.
Partial Key Lookup in SAS Hash Object
Partial key lookups are not directly supported in the SAS Hash Object. This post demonstrates a workaround to do partial key lookups in hash tables.
Select Into Multiple Macro Variables in SAS Proc SQL
The Select Into Clause in Proc SQL lets you create macro variables from SAS data sets. This post shows how to create multiple variables with Select Into.