Cody's Data Cleaning Techniques Using SAS, Second Edition

9 Correcting Errors

Introduction

Hardcoding Corrections

Describing Named Input

Reviewing the UPDATE Statement

Introduction

Now that you have developed techniques for detecting data errors, it’s time to think about how to correct the errors. The correcting process will vary, depending on your application. For example, you may have a large data warehouse where you can delete observations with errors (or possible errors) or replace possible data errors with missing values. For other applications, you may need to return to the original data forms, determine the correct values, and replace incorrect data values with corrected values.

Hardcoding Corrections

For small data sets where there are only a few corrections to be made, you may consider “hardcoding” ...