Merge with Caution: How to Avoid Common Problems When ...

were not ordered and are not relevant. In SQL parlance, we would like a left outer join, not a full outer join. While there are many ways this can be accomplished in the DATA step, a common approach is to use the IN= dataset option in conjunction with a subsetting IF statement as follows: data merge3b; merge orders(in=ordered) products; by ...

  Data