SAS Web Report Studio - how to count distinct values in crosstabs

Question

Hello,

in SAS Web Report Studio 3.1 I need to count distinct occurences for selected dimensions and display the results in a crosstable. According to the SAS Support Web site this aggregate function is not supported in cross tablulations, but maybe there is a work-around?

Thank you and best Regards Nadine

Answer 1

I don't think there is an easy way to do this. Web Report Studio just does not support "count distinct measures". I was at a SAS conference where they demo'ed 4.2 (?) that's included with the SAS 9.2 suite and that didn't appear to have any substantial functionality either. Just a bunch of interface improvements.

At my company we used a 3rd party product Futrix that sits on top of SAS and basically is a much more advanced version of Web report studio. It has count distinct measures built in. Basically, in terms of functionality Futrix is light years ahead of SAS Web Report Studio. Of course, it is not a free software, so I don't know how much this will help.

Bottom-line: Don't look to SAS Web Report studio if you want to implement any kind of serious web-based reporting.

Answer 2

Solution: Just create a new measure variable in info map. The expression for making this variable shall look like N ( Distinct <>) While creating WRS just drag and drop this field along with the other columns.