Data Quality for Analytics Using SAS

Chapter 10: Profiling and Imputation of Missing Values

10.1 Introduction

More than simple missing value reporting

Profiling missing values

Imputing missing values

SAS programs

10.2 Simple Profiling of Missing Values

General

Counting missing values with PROC MEANS

Using a macro for general profiling of missing values

10.3 Profiling the Structure of Missing Values

Introduction

The %MV_PROFILE_CHAIN macro

Data to illustrate the %MV_PROFILE_CHAIN macro

Simple reports based on the missing value profile chain

Advanced reports based on the missing value profile chain

Usage examples

Usage information for the %MV_PROFILING macro

10.4 Univariate Imputation of Missing Values with PROC STANDARD

General

Replacement values for the entire table

Replacement ...