| Description |
1 online resource (xii, 204 pages) : illustrations |
| Contents |
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 |
| Summary |
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 inc |
| Notes |
Includes index |
|
Description based upon print version of record |
|
Report 3-2: Out of Range Value Report |
| SUBJECT |
SAS (Computer file) http://id.loc.gov/authorities/names/n88028236
|
|
SAS (Computer file) fast |
| Subject |
SAS (Computer program language)
|
|
SAS (Computer program language)
|
| Form |
Electronic book
|
| ISBN |
9781952363016 |
|
1952363012 |
|
