Data.Cleaning.Techniques.Using.SAS.2nd

job · 发表于 2008-11-27 00:32:04

注册后推荐绑定QQ，之后方才可以使用下方的“用QQ帐号登录”。

您需要登录才可以下载或查看，没有账号？立即注册

x

Cody's Data Cleaning Techniques Using SAS, Second Edition
Cody's Data Cleaning Techniques Using SAS, Second Edition
By Ron Cody

Publisher:  SAS Press
Number Of Pages:  272
Publication Date:  2008-05-13
ISBN-10 / ASIN:  1599946599
ISBN-13 / EAN:  9781599946597
Binding:  Perfect Paperback

附件是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

Table of Contents
List of Programs ix
Preface xv
Acknowledgments xvii
Checking Values of Character Variables
Introduction 1
Using PROC FREQ to List Values 1
Description of the Raw Data File PATIENTS.TXT 2
Using a DATA Step to Check for Invalid Values 7
Describing the VERIFY, TRIM, MISSING, and NOTDIGIT Functions 9
Using PROC PRINT with a WHERE Statement to List Invalid Values 13
Using Formats to Check for Invalid Values 15
Using Informats to Remove Invalid Values 18
Che Checking Values of Numeric Variables
Introduction 23
Using PROC MEANS, PROC TABULATE, and PROC UNIVARIATE to Look
for Outliers 24
Using an ODS SELECT Statement to List Extreme Values 34
Using PROC UNIVARIATE Options to List More Extreme Observations 35
Using PROC UNIVARIATE to Look for Highest and Lowest Values by Percentage 37
Using PROC RANK to Look for Highest and Lowest Values by Percentage 43
Presenting a Program to List the Highest and Lowest Ten Values 47
Presenting a Macro to List the Highest and Lowest "n" Values 50
Using PROC PRINT with a WHERE Statement to List Invalid Data Values 52
Using a DATA Step to Check for Out-of-Range Values 54
Identifying Invalid Values versus Missing Values 55Listing Invalid (Character) Values in the Error Report 57
Creating a Macro for Range Checking 60
Checking Ranges for Several Variables 62
Using Formats to Check for Invalid Values 66
Using Informats to Filter Invalid Values 68
Checking a Range Using an Algorithm Based on Standard Deviation 71
Detecting Outliers Based on a Trimmed Mean and Standard Deviation 73
Presenting a Macro Based on Trimmed Statistics 76
Using the TRIM Option of PROC UNIVARIATE and ODS to Compute
Trimmed Statistics 80
Checking a Range Based on the Interquartile Range 86
Checking for Missing Values
Introduction 91
Inspecting the SAS Log 91
Using PROC MEANS and PROC FREQ to Count Missing Values 93
Using DATA Step Approaches to Identify and Count Missing Values 96
Searching for a Specific Numeric Value 100
Creating a Macro to Search for Specific Numeric Values 102
Working with Dates
Introduction 105
Checking Ranges for Dates (Using a DATA Step) 106
Checking Ranges for Dates (Using PROC PRINT) 107
Checking for Invalid Dates 108
Working with Dates in Nonstandard Form 111
Creating a SAS Date When the Day of the Month Is Missing 113
Suspending Error Checking for Known Invalid Dates 114
Checking a Range Using an Algorithm Based on the Standard Deviation 169
Checking for Missing Values 170
Range Checking for Dates 172
Checking for Duplicates 173
Identifying Subjects with "n" Observations Each 174
Checking for an ID in Each of Two Files 174
More Complicated Multi-File Rules 176
Corr Correcting Errors
Introduction 181
Hardcoding Corrections 181
Describing Named Input 182
Reviewing the UPDATE Statement 184
Corr Creating Integrity Constraints and Audit Trails
Introducing SAS Integrity Constraints 187
Demonstrating General Integrity Constraints 188
Deleting an Integrity Constraint Using PROC DATASETS 193
Creating an Audit Trail Data Set 193
Demonstrating an Integrity Constraint Involving More than One Variable 200
Demonstrating a Referential Constraint 202
Attempting to Delete a Primary Key When a Foreign Key Still Exists 205
Attempting to Add a Name to the Child Data Set 207
Demonstrating the Cascade Feature of a Referential Constraint 208
Demonstrating the SET NULL Feature of a Referential Constraint 210
Demonstrating How to Delete a Referential Constraint 211

lhenghui · 发表于 2008-11-29 09:17:57

一直就很烦数据清理啊，很想看看。8错8错。。。
3ks a lot！

lhenghui · 发表于 2008-11-29 09:21:34

一直想找的资料啊，再赞一个

ocsid · 发表于 2008-12-1 19:55:05

好东西!谢谢分享!

naivearies · 发表于 2009-3-23 09:38:37

谢谢分享好东西，不知道能不能下~

wolong · 发表于 2009-8-12 09:08:17

好东西！！！

缘梦缘 · 发表于 2009-8-16 08:11:25

前天刚接到一活，说安排明天去数据清理，看到该贴之前我还以为数据清理不就是找找异常值、缺失值吗？应该问题不大吧，不需要太大的技术吧，看了这贴后，突然一身冷汗，哈哈，还好今天让我看到这贴啦，不然明天可就要窘得不行啦，哈哈，十分感谢，赶紧恶补一下，如果有什么问题，喜欢能跟各位前辈交流，^_^

缘梦缘 · 发表于 2009-8-16 10:05:05

相关数据集下载网址：
http://www.cs.uiowa.edu/ftp/kcowles/datasets/

希望对大家有所帮助！^_^

tanzhen_epi · 发表于 2009-10-19 16:08:52

一个只要1个蹦儿，看看，看看

kay-1025 · 发表于 2010-2-3 17:43:12

{:5_235:}谢谢分享哦！

账号		自动登录	找回密码
密码			立即注册

[分享] Data.Cleaning.Techniques.Using.SAS.2nd

注册后推荐绑定QQ，之后方才可以使用下方的“用QQ帐号登录”。