Cody's Data Cleaning Techniques Using SAS, Second Edition

7 Double Entry and Verification (PROC COMPARE)

Introduction

Conducting a Simple Comparison of Two Data Sets

Using PROC COMPARE with Two Data Sets That Have an Unequal Number of Observations

Comparing Two Data Sets When Some Variables Are Not in Both Data Sets

Introduction

Many critical data applications require that you have the data entered twice and then compare the resulting files for discrepancies. This is usually referred to as double entry and verification. In the “old days,” when I was first learning to use computers, most data entry was done using a keypunch (although my boys will tell you that, in my day, it was done with a hammer and chisel on stone tablets). The most common method of double entry and verification was done on a special ...