Chapter 5. Combining Summary and Detail Data

Example 5.1 Adding Values to All Observations in a Data Set 110

Example 5.2 Adding Values from the Last Observation in a Data Set to All Observations in a Data Set 116

Example 5.3 Computing Summary Data and Combining Them with Detail Data 119

Example 5.4 Subsetting a Table Based on the Calculated Average of a Group 123

Example 5.5 Calculating Totals across a BY Group to Produce Cumulative and Grand Totals 126

Example 5.6 Calculating Percentages and Statistics That One Row Contributes to a BY Group 129

The examples in this chapter show ways of adding summary information to your detail data sets. This is usually a two-step process. The first step obtains or calculates the summary information. The second step adds this information to detail observations. Often the goal is to compute new variables from the combined detail and summary information.

All examples include both DATA step and PROC SQL solutions.