Creating a Distinct Count Value in SAS Information Map Studio


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.


About Author

Angela Hall

Senior Technical Architect

Angela offers tips on using the SAS Business Intelligence solutions. She manages a team of SAS Fraud Framework implementers within the SAS Solutions On-Demand organization. Angela also has co-written two books, 'Building BI using SAS, Content Development Examples' & 'The 50 Keys to Learning SAS Stored Processes'.

Related Posts

Comments are closed.

Back to Top