O'Reilly logo

The Little SAS® Book for Enterprise Guide® 4.1 by Lora D. Delwiche, Susan J. Slaughter

Stay ahead with the world's most comprehensive technology and business learning platform.

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, tutorials, and more.

Start Free Trial

No credit card required

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 ...

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, interactive tutorials, and more.

Start Free Trial

No credit card required