title '6g. User Controlled Levels, Formatted Order, Mixing Categorical and Continuous Data Rows'; data clevel; set sashelp.shoes; where product in (‘Boot’ ‘Slipper’); run; proc sort data= clevel nodupkey; by region product; run; proc tabulate data=sashelp.shoes missing classdata=clevel exclusive; class region product subsidiary; var stores sales inventory returns; * Product values and sales are rows by region values as columns; * N row for sales represent number of non-missing region and sales values; table product='Product' sales='Sales' * (n='N'*f=8. Nmiss=’Nmiss’*f=6. mean='Mean'*f=5.1 std='Std'*f=5.1 min='Min'*f=3. max='Max'*f=3.) ,(region=" ")(all = 'Total'); run;