Introduction

In previous chapters, SAS programs and macros were used to check for invalid data values. The rules were “hard-coded” or entered as calling arguments to SAS macros. In this chapter, you will see how data rules can be entered into a raw data file and turned into a SAS validation data set, with the data checking operation performed by a general purpose cleaning/validation program. This approach allows you to create permanent validation data sets, containing rules for frequently used variables, and to apply these validation data sets against any data set that needs to be validated. Finally, an introduction to SAS Integrity Constraints is presented. Integrity constraints allow you to store rules concerning your variables in the data ...

Get Cody’s Data Cleaning Techniques Using SAS® Software now with the O’Reilly learning platform.

O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.