title '11b. Product Distribution by Nesting by Region and Subsidiary with Subtotals';
proc tabulate data=sashelp.shoes missing;
 class region product subsidiary;
 var stores sales inventory returns;

* Subsidiary nested within region as rows by product counts as columns with subtotals;
 table (region='Region')*(subsidiary='Subsidiary' all), 
       product='Product'*(n='N'*f=5.0 pctn<subsidiary all>='%'*f=5.1);
run;