SAS Certification Prep Guide, 4th Edition

Summarizing and Grouping Data

Overview

Instead of just listing individual rows, you can use a summary function (also called an aggregate function) to produce a statistical summary of data in a table. For example, in the SELECT clause in the following query, the AVG function calculates the average (or mean) miles traveled by frequent-flyer club members. The GROUP BY clause tells PROC SQL to calculate and display the average for each membership group (MemberType).

proc sql; select membertype, avg(milestraveled) as AvgMilesTraveled from sasuser.frequentflyers group by membertype;

You should already be familiar with the list of summary ...