Date:         Tue, 7 Feb 2012 12:21:24 -0600
Reply-To:     mpajoh@ODOT.ORG
Sender:       "SAS(r) Discussion" <SAS-L@LISTSERV.UGA.EDU>
From:         Masoud Pajoh <mpajoh@ODOT.ORG>
Subject:      Proc Report
Content-Type: text/plain; charset="US-ASCII"

In the following:
proc report data=A split='\' nowd;
                title2 c=red "#byval1, #byval2";
                by pjprjnum cat;
                columns cat pjprjnum iplineno ilineno PrpItem idescr
quantity iunits estunitprice extestimate;
                define  pjprjnum                / noprint group;
                define  cat             / noprint group;
                define  ILineNo                 / display
style(COLUMN)={cellwidth=20mm just=center}              'Production Item
Number' ;
                define  IpLineNo                / display
style(COLUMN)={cellwidth=20mm just=center}              'Customer Item
Number' ;
                define  PrpItem                 / display
style(COLUMN)={cellwidth=20mm}                          ;
                define  Idescr                  / display
style(COLUMN)={cellwidth=65mm}                          ;
                define  Quantity                / display
style(COLUMN)={cellwidth=17mm}                          ;
                define  IUnits                  / display
style(COLUMN)={cellwidth=12mm just=center}                      ;
                define  estunitprice    / display style={cellwidth=20mm}
format=dollar13.2 ;
                define  extestimate             / display
style={cellwidth=20mm}  sum     format=dollar13.2       'Amount'  ;
        run;

        ods pdf close;
        title1; footnote1;

How can I print subtotals every time 'cat' changes, and subtotals when
pjprjnum changes, and grand total of all?
Thanks,

Masoud