Data Preparation for Analytics Using SAS

Chapter 27

Case Study 3—Preparing Data for Time Series Analysis

 

27.1 Introduction

27.2 The Business Context

27.3 The Data

27.4 From Transactional Data to the Most Appropriate Aggregation

27.5 Comparing PROC SQL, PROC MEANS, and PROC TIMESERIES

27.6 Additional Aggregations

27.7 Derived Variables

27.8 Creating Observations for Future Months

27.9 The Results and Their Usage

 

27.1  Introduction

In this case study we will show how we prepare data for time series analysis. We will use example data from a wholesale trader in the computer hardware industry. In this case study we will show how we can use these data to create longitudinal data marts that allow time series analysis on various hierarchical levels.

Different from the two previous case ...