Traditional web-based reporting with SAS BI tools

count distinct, group by in WRS

Accepted Solution Solved
Reply
Frequent Contributor
Posts: 133
Accepted Solution

count distinct, group by in WRS

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


Accepted Solutions
Solution
‎07-13-2016 11:37 AM
SAS Super FREQ
Posts: 465

Re: count distinct, group by in WRS

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.

View solution in original post


All Replies
SAS Super FREQ
Posts: 465

Re: count distinct, group by in WRS

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?

Frequent Contributor
Posts: 133

Re: count distinct, group by in WRS

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.

Solution
‎07-13-2016 11:37 AM
SAS Super FREQ
Posts: 465

Re: count distinct, group by in WRS

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.

☑ This topic is solved.

Need further help from the community? Please ask a new question.

Discussion stats
  • 3 replies
  • 363 views
  • 1 like
  • 2 in conversation