Chapter 8: Creating Data Aggregates and Metrics

8.1 Overview

8.2 Creating Simple Aggregates

8.2.1 Getting Variables from Other Tables

8.2.2 Calculating Unique Counts

8.2.3 Calculating Medians, Percentiles, Mode, and More

8.3 Creating Multi-Way Aggregates

8.3.1 Using Parameter Files to Define Aggregates

8.4 Summary

8.1 Overview

Creating data aggregates and metrics is a critical component of any business intelligence effort. Our users have asked us to provide a variety of examples that can be used by their management as well as the teams, players, and especially the fans to better understand the on-the-field performance metrics that are driving the success of the game. There is a long history of standard baseball metrics that are currently in use ...

Get Data Management Solutions Using SAS Hash Table Operations now with the O’Reilly learning platform.

O’Reilly members experience live online training, plus books, videos, and digital content from nearly 200 publishers.