- Browse
- » The data detective's toolkit: cutting-edge techniques and SAS macros to clean, prepare, and manage data
The data detective's toolkit: cutting-edge techniques and SAS macros to clean, prepare, and manage data
Average Rating
Author
Publisher
SAS Institute
Publication Date
[2020].
Language
English
Description
Loading Description...
Table of Contents
From the eBook
Intro
Contents
About This Book
What Does This Book Cover?
Is This Book for You?
What Are the Prerequisites for This Book?
What Should You Know about the Examples?
Software Used to Develop the Book's Content
Example Code and Data
Output and Graphics
We Want to Hear from You
About The Author
Acknowledgements
Chapter 1: Advantages of Using the Data Detective's Toolkit
Introduction
An Overview of the Data Detective's Toolkit
Table 1-1: List of Macro Programs in the Data Detective's Toolkit
%TK_codebook
%TK_inventory
%TK_xwalk
%TK_find_dups
%TK_harmony
%TK_skip_edit
%TK_max_length
Summary
Chapter 2: The Data Detective's Toolkit and SAS
Introduction
Preparing Your SAS Data Set
Types of Metadata
Using SAS to add Metadata to Your Data Set
Example 2-1: Adding Metadata to your SAS data set
Program 2-1: Program to Add Formats and Labels to a SAS Data Set
Specifications for Creating Formats and Labels
Create Formats (Step 1)
SAS Date Formats
Add Label to Data Set (Step 2)
Assign Formats (Step 3)
Variable Labels (Step 4)
Fundamental SAS Macro Concepts
What is the Macro Language?
Table 2-1: SAS Macro Date Variables
Table 2-2: SAS Macro Language Statements Used in This Book
Table 2-3: SAS Options for Macro Processing
Using the Data Detective's Toolkit Macro Programs
Example 2-2: Fixing Truncation of Data Values When Combining Data Sets
Output 2-1: Output to Examine Variables in Web Data
Output 2-2: Output to Examine Variables in the Teleform Data Set
Output 2-3: Listing Showing Truncated Values of Variable State
Program 2-2: Using %TK_max_length to Prevent Truncating Data Values When Combining Data Sets
Macro Syntax
Required Keyword Parameters
Output 2-4: Listing Showing the Correct Values of Variable State
Inside the Toolkit: %TK_max_length Macro
Program 2-3: The %TK_max_length and %get_length Macro Program Source Code
The Output Delivery System
Table 2-4: Partial List of ODS Destinations
Summary
Chapter 3: Codebooks: A Roadmap to Your Data
Introduction
Understanding Codebooks
Codebook 3-1: Example Codebook
Using the %TK_codebook Macro
Syntax
Required Keywords
Optional Keywords
A Word of Caution When Using Excel to Create Your Codebook
Ordering Variables in Codebook
Output Data Set
Table 3-1: Variables in Output Data Set Used to Create Codebook
Example 3-1: Create a Codebook with Potential Problem Reports
Program 3-1: Create Formats for Data Set
Program 3-2: Prepare Data Set with Formats and Labels
Program 3-3: Create a Codebook with the %TK_codebook Macro
Interpreting the Codebook
Codebook 3-2: Codebook with Problems to Illustrate the Potential Problem Reports
Understanding the Potential Problem Reports
Incomplete Format Report
Report 3-1: Incomplete Format Report
Out of Range Value Report
Excerpt
Loading Excerpt...
Author Notes
Loading Author Notes...
More Details
ISBN
9781952363016
9781952363009
9781952363009
Reviews from GoodReads
Loading GoodReads Reviews.
