The Data Detective's Toolkit

Additional Book Details

Reduce the cost and time of cleaning, managing, and preparing research data while also improving data quality!

Have you ever wished there was an easy way to reduce your workload and improve the quality of your data? The Data Detectives Toolkit: Cutting-Edge Techniques and SAS Macros to Clean, Prepare, and Manage Data will help you automate many of the labor-intensive tasks needed to turn raw data into high-quality, analysis-ready data. You will find the right tools and techniques in this book to reduce the amount of time needed to clean, edit, validate, and document your data. These tools include SAS macros as well as ingenious ways of using SAS procedures and functions.

The innovative logic built into the books macro programs enables you to monitor the quality of your data using information from the formats and labels created for the variables in your data set. The book explains how to harmonize data sets that need to be combined and automate data cleaning tasks to detect errors in data including out-of-range values, inconsistent flow through skip paths, missing data, no variation in values for a variable, and duplicates. By the end of this book, you will be able to automatically produce codebooks, crosswalks, and data catalogs.

Additional resources for this book can be found by accessing the link below.

Book Reviews

Why reinvent the wheel when the SAS macros in The Data Detective's Toolkit are easy to apply and customize for a professional approach to better understanding and processing new data? - Sunil Gupta, Founder of SASSavvy.com

This book is absolutely packed full of useful information to any user of SAS, whether youre a novice or an expert. Chantala has created a series of macros that allow SAS to provide the user with a huge variety of extraordinarily useful information, from creating codebooks to analyzing data that has skip patterns (also known as conditional logic). Youll be going back to this book over and over again. - Chris Battiston, Research Data Analyst,
Womens College Hospital