Cross tabulations in SAS Web Report Studio don't work with just category/qualitative data. A measure is required. So how to count the number of records that exist in the group?
Using the SASHELP.SHOES data table, we would like to count the number of subsidaries that exist within a region, or are selling each product.
In the example below, we have added a ‘Distinct Subsidary’ calculated measure in SAS Information Map Studio.
The Expression Text is
N ( Distinct <> )
In SAS Web Report Studio, simply use the table insert (not the cross tabular insert) and select the variables to display. If you select Product, and Distinct Subsidary, a table with two columns will appear and this will answer the question of how many subsidaries are selling each of the products.