Suppress GrandTotal

deleted_user — Mon, 03 Aug 2009 16:08:43 GMT

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 ;

Re: Suppress GrandTotal

Cynthia_sas — Mon, 03 Aug 2009 16:42:58 GMT

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]

topic Re: Suppress GrandTotal in ODS and Base Reporting

Suppress GrandTotal

Re: Suppress GrandTotal