topic count distinct, group by in WRS in SAS Web Report Studio

count distinct, group by in WRS

metallon — Wed, 06 Jul 2016 13:53:09 GMT

Hello,

searching the web I gathered that a count distinct is not possible using WRS.

I have various clients groups that need to count disintct amongst different variables (group by)

does that mean I need to create X SAS Information Maps to address all those different grouping variable requirements?

Bye

Re: count distinct, group by in WRS

Madelyn_SAS — Wed, 06 Jul 2016 18:15:20 GMT

If you are using at least 4.2_M2, you should be able to use distinct aggregation types such as COUNT(Distinct), AVG(Distinct), and SUM(Distinct). Are you seeing an error when you try to use it?

Re: count distinct, group by in WRS

metallon — Fri, 08 Jul 2016 10:35:57 GMT

Hi,
Thanks for the reply.
I got WRS 4_4.
When I select 4 elements (categories) from my dataset, all alphanumeric and no measures. I cant find
a way in the UI to count distinct ( categoryA) group by categoryB, categoryC, categoryD.
I am reasing the giant 370p user manual but no luck so far.

Re: count distinct, group by in WRS

Madelyn_SAS — Tue, 12 Jul 2016 18:19:08 GMT

I"m sorry, but I think I misunderstood your original question. You are correct that you cannot create the count distinct data item in Web Report Studio. You would have to create the count distinct data item in the information map.