Once again, I have taken a look at my SAS Shelf. Back in june 2018, I showed you Three New Additions to my SAS Shelf. Since then, I have acquired a few new books and I want to share my thoughts on them. This time, I have 5 books in quite different topics like the SQL...
Most SAS programmers know about the Set Statement and the Merge Statement in the Data Step. Fewer know about the Update Statement. It is not as common as the two. However, it can be a quite handy tool under the right circumstances. This post demonstrates how to use...
The Do While and Do Until loops are two seemingly similar constructs in SAS. However, they are actually very different. In this post, I will present three cases where the Do While and Do Until loops differ. Also, I will shortly discuss when to use which one. 1. Do...
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,...
Once in a while, you see a SAS programming statement that makes little sense. For many, the If 0 Then Set data step Statement is one of them. This post demonstrates what the statement does and why it can be convenient by example. A SAS data step runs in two overall...
In the blog post Writing User Defined Formats in SAS with PROC FORMAT, I briefly introduce Picture Formats. Picture formats are templates for printing numbers. They are extremely flexible if you use them correctly. To do so, you should familiarize yourself with the...