The ALL statistic can provide total over the SHIP_DATEs at
( ship_date=' '*(both='Total (mg)'*sum=' ' nordi='% Nordi'*pctsum=' '*F=7.1
ALL='2009H1'* both='Total (mg)'*sum=' ' )
however, order is more of a problem.
There is a proc statement option "order= data" that might help, but you would have to prepare the total of both quarters and apply to each, before sorting the data.
I'm not certain that that would work.
A first try: sort into order for totalling BOTH[pre] proc sort data= master_cvv1 out= prep1 ;
by correct_name city state zip1 Ghtm ;
run ;[/pre] * now a double pass, first to get the total across all ship_date (i.e. within GHTM ) ;
* second to output the data with the exta column=Tboth= total of "both" within GHTM;[pre]data prep2 ;
set prep1(in= first ) prep1( in= second ) ;
by correct_name city state zip1 Ghtm ;
if first.ghtm then tboth=0 ;
if first then tboth + both ;
if second then output ;
run ;[/pre]* finally sort into the output order and hope it "sticks" ;[pre]proc sort out= prep3 ;
by correct_name city state zip1 Ghtm
descending tboth ;
run ;[/pre]then run your tabulatelike[pre]proc tabulate data= prep3 format= 5. order=data ;[/pre]
and let us know how it goes
PeterC