Cody's Data Cleaning Techniques Using SAS Software | List Price: $39.95
Discount Price: $29.99
|
Binding: Paperback
Excellent As Usual! [Posted on 2003-12-04]
Ron Cody is the master of SAS educational books: His clear informal style is undaunting, he supplies plenty of examples, and he explains both what you need to know and why you need to know it. 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!
Click here for more details and discount information...
|
){kind=link}