Cody's Data Cleaning Techniques Using SAS Software - Softcover

Ronald P. Cody

Softcover

ISBN 10: 1580256007 ISBN 13: 9781580256001

Publisher: SAS Publishing, 1999

Synopsis

The key to ensuring accurate data is having clean data. This book develops and describes data cleaning programs and macros. You can use many of the programs and macros that are provided, as is, or you can modify them for your own special data cleaning tasks. Ron has carefully explained and documented each of the programs and macros, thus providing you with SAS programming instruction on an intermediate-to-advanced level. Topics presented include validation checks on character data, numeric data, missing values, and date values; searching for duplicate records; working with multiple files; double entry and verification using the COMPARE procedure; and SQL solutions and using validation data sets. Written in Ron's signature informal, tutorial style, this book gives anyone who manages data thoroughly documented, step-by-step instructions for the development of data cleaning programs and macros.

Supports releases 6.12 and higher of SAS software.

About this title

About the Author

Ron Cody, Ed.D.

Ron Cody has over 20 years of experience using and teaching the SAS System. As author of The SAS Workbook and Solutions and coauthor of two other successful SAS programming books, SAS Programming by Examples and Applied Statistics and the SAS Programming Language, Fourth Edition, Ron brings expert writing and programming skills to his newest SAS book. He has been a prolific and popular contributor to national, regional, and local user group conferences. In his spare time, Ron is a professor and researcher at the Robert Wood Johnson Medical School.

Review

Cody's Data Cleaning Techniques Using SAS Software will become the 'bible' for any person whose responsibility is to collect data for further analysis. Ron extensively covers, with numerous examples, the tedious task of validating raw data. Written for the novice SAS user with easy-to-follow code, but comprehensive enough that any experienced user will find data cleaning techniques to add to their tool box. --Bob Schechter, Systems Engineer, AstraZeneca Pharmaceuticals

Cody's Data Cleaning Techniques Using SAS Software is the perfect solution for anyone faced with the problems of dealing with messy data. This is an easy-to-follow, very comprehensive exploration of the techniques needed to get data in shape for analysis and reporting. It is an ideal book for the beginning SAS user, loaded with many clear examples of different types of data problems and step-by-step explanations of the solutions. Intermediate and advanced SAS users will also find it quite beneficial. It provides a solid introduction to new data cleaning features available with SAS 7 and 8 and is an ideal refresher for often overlooked, simple solutions. This book is a 'must have' addition to the SAS library of anyone who prepares and cleans data for analysis and reporting. --S. David Riba, CEO, JADE Tech, Inc.

The author, Ron Cody, has a well-deserved reputation in the SAS world as a writer and as a speaker, with several other books and professional papers to his credit. In this book Ron uses an informal, almost chatty style to present various methods to verify the contents of input data sets. Ron ensures that the reader understands WHY a particular solution was suggested and HOW it actually works. However, if the reader only takes the material at face value, he is doing himself a great disservice. Cody's Data Cleaning Techniques Using SAS Software can be used as a fantastic tool to learn some general SAS usage techniques! The beginning SAS programmer can find numerous examples of how to apply various DATA step tools such as formats and functions, and PROCs such as FORMAT, TABULATE, and UNIVARIATE, to real-world examples. The principles discussed in Ron's book can easily be understood and applied by those who have no interest in the stated topic of 'data cleaning.' Even the more experienced SAS programmer can find techniques that they might not have thought of independently. And, for those who want further information about the coding techniques, Ron frequently includes references to outside materials that delve further into the current topic. Overall, I found this to be an outstanding publication, and it will be an excellent addition to my professional library. --Andrew T. Kuligowski, Southeast SAS Users Group

Edition details

• Publisher: SAS Publishing
• Publication date: 1999
• ISBN 10: 1580256007
• ISBN 13: 9781580256001
• Binding: Paperback
• Language: English
• Edition number: 1
• Number of pages: 226