Understand the _N_ Automatic Variable in SAS
This post is devoted to the automatic _N_ variable in SAS. I will introduce the variable, provide a few examples and some common misconceptions.
The 5 Hash Iterator Object Methods in SAS
This post is devoted to the five methods related to the hash iterator object in SAS. These are the First, Last, Next, Prev and Setcur Method.
An Introduction to the SAS Hash Iterator
This post introduces the hash iterator object. I will explain the basics of the object and show an example of how to iterate through a hash object.
Pass Function Logic to PROC FORMAT
This post demonstrates how to utilize the flexibility of PROC FORMAT by applying function logic to SAS formats with PROC FCMP.
Set All Array Elements to Zero in SAS
When you use an array in a SAS data step, sometimes you need to reinitialize the array elements to some value. For example zero or one. Not long ago, I learned a nifty little trick that allows you to do so easily. This post demonstrates four different methods to set...
Write Custom Date and Datetime Formats in SAS
This post demonstrates how to use PROC FORMAT to write user defined date and datetime formats exactly the way you want them.
Understand the Dosubl Function in SAS
The aim of this post is to help you understand the Dosubl Function. I will present a few examples and explain how it differs from Call Execute.
Use Temporary Arrays to Store Lagged Values in SAS
This post shows an example of how to use a temporary array to store lagged values. This enables you to compute lags. Without the Lag Function.
Dynamically Change Data Set Attributes in SAS
This post demonstrates how to change formats, variables names and data set names dynamically in SAS with metadata and Call Execute logic.
Dynamic Programming in SAS with CALL EXECUTE
Call Execute is a common routine in SAS. This post shows you by example how the SAS Call Execute Routine creates data-driven programs.