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.6. Adding a Grand Total to a Data Table

Using the Query Builder, you can create columns that contain summary statistics for existing columns. For example, you may want to calculate a grand total over all the rows of data and put the result in a new column. Then you could compute the percent of the total for each row because the one grand total value is repeated for each row in the data.

Here is a sample of the AdResults data which contains the amounts spent on advertising for the Fire and Ice Tours company for both its Seattle and Portland offices. To create a new column that has the total amount spent for both offices for the time period, click the data icon in the Project Explorer or Project Designer to make it active, and then open the ...

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