Cody's Data Cleaning Techniques Using SAS Software

The key to ensuring accurate data is having clean data. This book develops and describes data cleaning programs and macros. You can use many of the programs and macros that are provided, as is, or you can modify them for your own special data cleaning tasks. Ron has carefully explained and documented each of the programs and macros, thus providing you with SAS programming instruction on an intermediate-to-advanced level. Topics presented include validation checks on character data, numeric data, missing values, and date values; searching for duplicate records; working with multiple files; double entry and verification using the COMPARE procedure; and SQL solutions and using validation data sets. Written in Ron's signature informal, tutorial style, this book gives anyone who manages data thoroughly documented, step-by-step instructions for the development of data cleaning programs and macros.

Supports releases 6.12 and higher of SAS software.

Ron Cody, Ed.D.

Ron Cody has over 20 years of experience using and teaching the SAS System. As author of The SAS Workbook and Solutions and coauthor of two other successful SAS programming books, SAS Programming by Examples and Applied Statistics and the SAS Programming Language, Fourth Edition, Ron brings expert writing and programming skills to his newest SAS book. He has been a prolific and popular contributor to national, regional, and local user group conferences. In his spare time, Ron is a professor and researcher at the Robert Wood Johnson Medical School.