Cody's Data Cleaning Techniques Using SAS Software

Author: Ronald P. Cody, Ron Cody, Art Ginsburg List Price: $37.95 Our Price: Click to see the latest and low price ISBN: 1580256007 Publisher: SAS Publishing (January, 2000) Edition: Paperback Sales Rank: 57,779 Average Customer Rating: 5 out of 5

Buy now directly from Amazon.com -

Customer Reviews

Many books teach SAS programming, but few of them explain how to identify "hidden" errors, such as duplicate observations, out-of-range or missing values, and whether an ID value is in each of two or more files. These are important checks, because programs will often run and look fine, even though they may contain these database errors (or, if not errors, assumptions that are not true).

The majority of the book is for intermediate to advanced users who set up databases for statistical manipulation. Although Cody tries to simplify things, it appeared that some techniques such as PROC SQL and macros assume some prior basic knowledge. However, as evident from the chapters listed below, there are valuable lessons that will help intermediate (and even some "advanced beginners" ) level users.

Chapters:
1. Checking Values of Character Variables
2. Checking Values of Numeric Variables
3. Checking for Missing Values
4. Working with Dates
5. Looking for Duplicates and "n" Observations per Subject
6. Working with Multiple Files
7. Double Entry and Verification (PROC COMPARE)
8. Some SQL Solutions to Data Cleaning
9. Using Validation Data Sets
Appendix: Listing of Raw Data Files and SAS Programs

There are lots of program examples and output that really make this a useful book. 226 pages, including index. Another great job by this author!

Similar Products