Merge with Caution: How to Avoid Common Problems when Combining SAS Datasets

Josh Horstman
Nested Loop Consulting


Abstract

Although merging is one of the most frequently performed operations when manipulating SAS datasets, there are many problems which can occur, some of which can be rather subtle. This paper examines several common issues, provides examples to illustrate what can go wrong and why, and discusses best practices to avoid unintended consequences when merging.