SAS 9.4 SQL Procedure User's Guide, Second Edition, 2nd Edition

Summarizing Data in Multiple Columns

Problem

You want to produce a grand total of multiple columns in a table.

Background Information

There is one input table, called Sales, that contains the following data:

data Sales;

input Salesperson $ January February March;

datalines;

Smith 1000 650 800

Johnson 0 900 900

Reed 1200 700 850

Davis 1050 900 1000

Thompson 750 850 1000

Peterson 900 600 500

Jones 800 900 1200

Murphy 700 800 700

Garcia 400 1200 1150

;

proc print data=Sales;

title 'Sample Data for Summarizing Data from Multiple Columns';

run;

192 Chapter 6 • Practical Problem-Solving with PROC SQL

Output 6.13 Sample Input Table for Summarizing Data from Multiple ...