SAS Institute. The Power to Know

Learning Center

More Information

Book Extras

Keep in Touch

SAS Press» Companion Site

Cody's Data Cleaning Techniques Using SAS, Second Edition

About the Book

book cover Cody's Data Cleaning Techniques Using SAS, Second Edition
By: Ron Cody
ISBN: 978-1-59994-659-7
Pages: 230


Order this book from our online bookstore

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.

About the Author

author photo Ron Cody, Ed.D., is a retired professor from the Robert Wood Johnson Medical School who now works as a private consultant and a national instructor for SAS Institute Inc. 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; SAS Programming by Example; Applied Statistics and the SAS Programming Language, Fifth Edition; The SAS Workbook; The SAS Workbook Solutions; Cody's Data Cleaning Techniques Using SAS Software; Longitudinal Data and SAS: A Programmer's Guide; and SAS Functions by Example, as well as countless articles in medical and scientific journals.

Samples and Tips, Blogs, and More

Podcast