Название: The Data Detective's Toolkit: Cutting-Edge Techniques and SAS Macros to Clean, Prepare, and Manage Data
Автор: Kim Chantala
Издательство: SAS Institute
Год: 2020
Страниц: 216
Язык: английский
Формат: pdf (true), azw3
Размер: 10.1 MB

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 Detective’s 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 book’s 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.

Is This Book for You?
This book is designed to help automate many of the tasks performed to turn raw data into analysis-friendly data. These tasks are often filled with a mix of irksome and strenuous activities that stand between you and data that can be used. This book will help preparers of the data in different ways.

What Are the Prerequisites for This Book?
Familiarity with SAS programming (the DATA step and basic rules of the SAS language) as well as manipulating SAS data with procedures such as PROC CONTENTS, PROC MEANS, and PROC FREQ provide adequate prerequisites for working with the SAS programs and techniques discussed in this book. Familiarity with basic features of the SAS macro language would be useful to run the SAS macro programs that accompany this book. For programmers new to the SAS macro language, detailed instruction is provided in Chapter 2 with information about using SAS.