Read more
Find errors and clean up data easily using SAS!
Thoroughly updated, Cody's Data Cleaning Techniques Using SAS, Third Edition, addresses tasks that nearly every data analyst 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 which will make your job of data cleaning easier, faster, and more efficient.
Building on both the author's experience gained from teaching a data cleaning course for over 10 years, and advances in SAS, this third edition includes four new chapters, covering topics such as the use of Perl regular expressions for checking the format of character values (such as zip codes or email addresses) and how to standardize company names and addresses.
With this book, you will learn how to:
find and correct errors in character and numeric values
develop programming techniques related to dates and missing values
deal with highly skewed data
develop techniques for correcting your data errors
use integrity constraints and audit trails to prevent errors from being added to a clean data set
About the author
Ron Cody, EdD, is a retired professor from the Rutgers Robert Wood Johnson Medical School who now works as a private consultant and national instructor for SAS. A SAS user since 1977, Ron's extensive knowledge and innovative style have made him a popular presenter at local, regional, and national SAS conferences. He has authored or co-authored numerous books, such as Learning SAS by Example: A Programmer's Guide, Second Edition; A Gentle Introduction to Statistics Using SAS Studio; Cody's Data Cleaning Techniques Using SAS, Third Edition; SAS Functions by Example, Second Edition; and several other books on SAS programming and statistical analysis. During his career at Rutgers Medical School, he authored or co-authored over 100 articles in scientific journals.
