The SAS Output Delivery System and reporting techniques

Suppress GrandTotal

Reply
N/A
Posts: 0

Suppress GrandTotal

The following code report prints fine with subtotals and a grandtotal -- however, I don't want the grandtotal to print/display -- what code will suppress grand total line?

proc print data = b2 uniform label ;
by co_id ;
id co_id ;
var Ped Recordcnt Wellcnt Ownercnt Checkcnt WIcnt WInetamt RIcnt RInetamt;
sum Recordcnt Wellcnt Ownercnt Checkcnt WIcnt WInetamt RIcnt RInetamt;
*format Amount Comma15.2 ;
title Detail Sales History Data -- Statistics ;
title2 (Excludes Deleted Interest Owner);
run ;
SAS Super FREQ
Posts: 8,868

Re: Suppress GrandTotal

Posted in reply to deleted_user
Hi:
With PROC PRINT, the SUM statement does both subtotals and grand totals and you do not have the ability to get one without getting the other. (Without a BY statement, you would only get grand totals).

However, PROC REPORT does allow you to request either subtotals or grand totals independently of each other. The converted code would be something like what's shown below.

You'll have to read about the DEFINE statement and various USAGE options. For more information on PROC REPORT, I recommend:
http://support.sas.com/documentation/onlinedoc/v82/techreport_p258.pdf

I only included a DEFINE statement for CO_ID, so that the BREAK statement could be used. I was not sure what usage you would want for PED (DISPLAY?? ORDER??) If you
-wanted- grand totals, you would explicitly have to use an RBREAK statement.

cynthia
[pre]
proc report data = b2 nowd;
column co_id Ped Recordcnt Wellcnt Ownercnt Checkcnt WIcnt WInetamt RIcnt RInetamt;
define co_id / order;
break after co_id/summarize skip;
title Detail Sales History Data -- Statistics ;
title2 (Excludes Deleted Interest Owner);
run ;
[/pre]
Ask a Question
Discussion stats
  • 1 reply
  • 532 views
  • 0 likes
  • 2 in conversation