Thoroughly updated for SAS 9, Cody's Data Cleaning Techniques Using SAS, Second Edition, addresses tasks that nearly every SAS programmer needs to do - that is, make sure that data errors are located and corrected. Written in Ron Cody's signature informal, tutorial style, this book develops and demonstrates data cleaning programs and macros that you can use as written or modify for your own special data cleaning needs. Each topic is developed through specific examples, and every program and macro is explained in detail.

You'll learn how to

find and correct errors in character and numeric values

develop programming techniques related to dates and missing values

use SQL approaches to data cleaning

develop techniques for correcting your data errors

use integrity constraints and audit trails to prevent errors from being added to a clean data set

Novice and experienced SAS users will discover ways to detect and correct data errors while learning how to apply DATA step programming techniques and SAS procedures.

Amazon.com® Reader Reviews (Ranked by Helpfulness)

Average Amazon.com® Rating:  Based on 1 Ratings

Great book. Easy to read ! - 2009-01-14
Reviewer Rating:
Like other books by Ron Cody, this book is easy to read and understand. The explanation is clear with different examples and ways to write the SAS codes to achieve similar objectives but to suit different situations. You can download the programs and data sets from SAS website to try the codes without typing it yourselves. I normally had problems focusing on a book for a long time and skipped exercises to finish the book the earliest. It did not happen to me when reading this book. Moreover the book covers all the key problems with data especially when you touch it the first time. Even if you are a SAS expert, you will be surprised to learn a better way to code SAS. I highly recommend this book.

Browse Similar Topics

Top Level Categories:
Business
Programming

Sub-Categories:
Business > Statistics
Programming > SAS