proc report data=sashelp.shoes nowd;
where region in ('Asia', 'Canada') and product in ('Boot','Slipper') and Subsidiary in('Montreal','Toronto','Seoul','Bangkok');
columns region Subsidiary sales,product sales=s;
define region/group noprint;
define Subsidiary /group ' ' ;
define product/across ' ';
define sales/analysis sum ' ' format=comma32.;
define s/analysis sum 'Total' format=comma32.;
compute after region;
Subsidiary='Total';
endcomp;
compute before region/style=header{just=l};
line region $80.;
endcomp;
break after region/summarize ;
run;
... View more