Cody's Data Cleaning Techniques Using SAS, Second Edition

Table of Contents

List of Programs

Preface

Acknowledgments

1 Checking Values of Character Variables

Introduction

Using PROC FREQ to List Values

Description of the Raw Data File PATIENTS.TXT

Using a DATA Step to Check for Invalid Values

Describing the VERIFY, TRIM, MISSING, and NOTDIGIT Functions

Using PROC PRINT with a WHERE Statement to List Invalid Values

Using Formats to Check for Invalid Values

Using Informats to Remove Invalid Values

2 Checking Values of Numeric Variables

Introduction

Using PROC MEANS, PROC TABULATE, and PROC UNIVARIATE to Look for Outliers

Using an ODS SELECT Statement to List Extreme Values

Using PROC UNIVARIATE Options to List More Extreme Observations

Using PROC UNIVARIATE to Look for Highest and Lowest Values by Percentage ...