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. SAS Products and Releases: Base SAS: 9.2, 9.1.3, 9.1.2, 9.1, 9.0 SAS/STAT: 9.2, 9.1.3, 9.1.2, 9.1, 9.0 Operating Systems: All

Table of Contents 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` Obsernations 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. Creationg Intergrity Constraints and Audit Trails 11. DataFlux and df Power Studio Appendix : Listing of Raw Data Files and SAS Programs