Five New Additions to my SAS Shelf

Five New Additions to my SAS Shelf

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...
Using the Update Statement in the SAS Data Step

Using the Update Statement in the SAS Data Step

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...
Do While Loop vs Do Until Explained in SAS

Do While Loop vs Do Until Explained in SAS

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...
Creating Multilabel Formats in SAS with PROC FORMAT

Creating Multilabel Formats in SAS with PROC FORMAT

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,...
The Meaning of If 0 Then Set in SAS Data Step

The Meaning of If 0 Then Set in SAS Data Step

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...
5 SAS Picture Format Options You Should Know

5 SAS Picture Format Options You Should Know

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...