Cody's Data Cleaning Techniques Using SAS, Second Edition

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

Using PROC RANK to Look for Highest and Lowest Values by Percentage

Presenting a Program to List the Highest and Lowest Ten Values

Presenting a Macro to List the Highest and Lowest “n” Values

Using PROC PRINT with a WHERE Statement to List Invalid Data Values

Using a DATA Step to Check for Out-of-Range Values

Identifying Invalid Values versus Missing Values

Listing Invalid (Character) Values in the Error Report

Creating a Macro for ...