Cody's Data Cleaning Techniques Using SAS, Second Edition

6 Working with Multiple Files

Introduction

Checking for an ID in Each of Two Files

Checking for an ID in Each of "n" Files

A Macro for ID Checking

More Complicated Multi-File Rules

Checking That the Dates Are in the Proper Order

Introduction

This chapter addresses data validation techniques where multiple files or data sets are involved. You will see how to verify that a given ID exists in multiple files and how to verify some more complicated multi-file rules. Because it is impossible to anticipate all the possible multi-file rules you may need, much of this chapter is devoted to programming tips and techniques rather than actual examples that you can use directly.

Checking for an ID in Each of Two Files

One requirement of a large project ...