Data Quality for Analytics Using SAS

Chapter 11: Profiling and Replacement of Missing Data in a Time Series

11.1 Introduction

General

SAS programs

11.2 Profiling the Structure of Missing Values for Time Series Data

Missing values in a time series

Example data

The TS_PROFILE_CHAIN

Reports for profiling a time series

Macro %PROFILE_TS_MV

11.3 Checking and Assuring the Contiguity of Time Series Data

Difference between transactional data and time series data

Example of a non-contiguous time series

Checking and assuring contiguity

PROC TIMESERIES

Macro implementation and usage

11.4 Replacing Missing Values in Time Series Data with PROC TIMESERIES

Overview

Functionality of PROC TIMESERIES

Examples

Changing zero values to missing values

11.5 Interpolating Missing Values in Time Series ...