The Little SAS® Book for Enterprise Guide® 4.1

4.8. Creating Summary Data Tables in a Query

The previous section showed how you can create new columns that summarize all the rows belonging to a group. The summarized values were repeated for each row that belonged to the group. But if you want only one row for each group showing just the summarized values, you can do this in a query by eliminating all columns that are not either grouped or summarized.

Here is a sample of the AdResults data which contains the amounts spent on advertising for the Fire and Ice Tours company for its Seattle and Portland offices. To create a new table that has the total number of bookings for each office and the total amount spent by each office, click the AdResults data icon in the Project Explorer or Project ...