大家好:
附件是Cody’s Data Cleaning Techniques Using SAS, 2nd Edition.pdf文件,由SAS公司2008年5月出版,272页,原价39.95美金。
Review
"Clean data is critical to accurate analysis. By implementing programs and macros in Cody's Data Cleaning Techniques Using SAS, Second Edition, you can achieve the goal of a clean SAS data set. Easy-to-follow examples identify invalid, missing, or out-of-range data. Also included are chapters working with dates and matching Primary Key (Identifier) variables across multiple files. This Second Edition incorporates new features in SAS9.
This book is a valuable tool for all SAS users to prepare data for analysis." --Karol Katz, MS, Programmer/Analyst, Yale University School of Medicine
"Many veteran coders become comfortable - sometimes too comfortable - with the coding techniques that they learned early on in their careers. They believe that there is no need to adopt enhanced features since their old skills continue to provide an adequate return. Dr. Ron Cody is NOT one of those people; his published works on SAS embrace the changes that have occurred in the SAS language over the years. Some of his books, most notably SAS Functions by Example and Learning SAS by Example: A Programmer's Guide, are benchmarks by which other books should be measured. He's now taken one of his earlier works, Cody's Data Cleaning Techniques Using SAS Software and updated it to take advantage of what SAS has introduced in the 9 years since the original version was published.
Folks who purchased his original volume should be prepared to put their first copy away and begin to use the newer work at their earliest opportunity." --Andrew T. Kuligowski, SouthEast SAS Users Group
Product Description
Thoroughly updated for SAS 9, this 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.
书的目录如下:
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 PROC SQL Solutions to Data Cleaning
9 Correcting Errors
10 Creating Integrity Constraints and Audit Trails
11 DataFlux and dfPower Studio