Dictionary Tables and SASHELP Views in SAS
This post demonstrates how to extract metadata in SAS with with PROC SQL and the Data Step from the Dictionary Tables and SASHELP Views.
Using the Modify Statement in the SAS Data Step
Too few SAS programmers know about the Modify Statement. Some call it the most underutilized statement in SAS. This post shows a few examples.
5 Tips to Learn and Understand the Hash Object in SAS
I have written quite a lot about SAS Hash Objects. Here, I present 5 tips to learn and understand the hash object in SAS and some learning material to get your going.
Create Rolling Statistics With PROC SQL in SAS
There are numerous ways to create rolling statistics in SAS. This post demonstrates how to use PROC SQL to create rolling statistics.
SAS Cartesian Product with PROC SQL and the Data Step
This post demonstrates two ways to create a cartesian product in SAS. One example with PROC SQL and one with the SAS data step.
Using the Update Statement in the SAS Data Step
Too few SAS programmers know about the Update Statement. This post demonstrates by example how to use the Data Step Update Statement in SAS.
Do While Loop vs Do Until Explained in SAS
The Do Until and Do While loops are two widely different loops in SAS. This post explains the main differences between the two.
Assigned Vs Unassigned Hash Object Method Call in SAS
When you call a method in a SAS hash object, you either call it assigned or unassigned. This post explains the difference and why it is important.
Why Arrays Should be _TEMPORARY_ When Possible
SAS arrays are a must-know in SAS programming. This post demonstrates by example why arrays should remain temporary when possible.
The Difference Between NodupKey and NoDup in PROC SORT
This post demonstrates the difference between the Nodupkey and the Nodup Option in SAS PROC SORT. So similar names, yet so different results.