Implicit Vs Explicit Arrays in SAS
This post explains the common explicit array and the old implicit array. I discuss pros and cons and why the implicit array is not even documented anymore.
A Closer Look at the Quicksort Algorithm in SAS
This post introduces the quicksort algorithm from a SAS point of view.Wee see how the quicksort algortithm is coded in SAS and a few examples.
4 Techniques To Sort An Array in SAS
This post demonstrates four different techniques to sort an array in SAS. Using Proc Sort, Call Sortn, the hash object and the quicksort algorithm.
Understand the Return Statement in SAS
This post is devoted to the understanding of the Return Statement in the SAS Data Step. Rarely explicitly used, but almost always implicitly present.
Using Suminc and Keysum in SAS Hash Object
This post demonstrates how to use the Suminc and Keysum arguments in the SAS hash object Declare Statement. Rarely used and few understand them.
A SAS Macro Approach to Array Hashing
In this post, I will demonstrate how to use SAS macros, that simulate hashing methods with arrays. Without using the actual hash object.
Bitmap Search Technique in the SAS Data Step
This post demonstrates how to do a bitmap search in the SAS Data Step to verify the presence of a key with minimal memory and maximum speed.
Create Custom Sort Order in SAS
This post demonstrates how to create a custom sort order in SAS with PROC SQL and FORMAT. When descending or ascending order is not sufficient.
Indentify Connected Components in SAS with PROC OPTNET
This post demonstrated how to identify and group connected components in a SAS data set with the hash object and PROC OPTNET.
Passing an Array as Argument in PROC FCMP
This post demonstrates how to pass a SAS array as argument to functions and subroutines in PROC FCMP in SAS. By reference and value.