\u003cp\u003e\u003cb\u003eFind errors and clean up data easily using SAS!\u003c/p\u003e\u003c/b\u003e \n\n\u003cp\u003eThoroughly updated, \u003ci\u003eCody's Data Cleaning Techniques Using SAS, Third Edition\u003c/i\u003e, 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.\u003c/p\u003e \n\n\u003cp\u003eBuilding 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.\u003c/p\u003e \n\n\u003cp\u003eWith this book, you will learn how to:\u003c/p\u003e\u003cul\u003e \n\u003cli\u003efind and correct errors in character and numeric values \n\u003cli\u003edevelop programming techniques related to dates and missing values \n\u003cli\u003edeal with highly skewed data \n\u003cli\u003edevelop techniques for correcting your data errors \n\u003cli\u003euse integrity constraints and audit trails to prevent errors from being added to a clean data set\u003c/ul\u003e\u003c/p\u003e