Cody’s Data Cleaning Techniques Using SAS® Software

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.