BookmarkSubscribeRSS Feed
🔒 This topic is solved and locked. Need further help from the community? Please sign in and ask a new question.
metallon
Pyrite | Level 9

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

1 ACCEPTED SOLUTION

Accepted Solutions
Madelyn_SAS
SAS Super FREQ

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

3 REPLIES 3
Madelyn_SAS
SAS Super FREQ

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?

metallon
Pyrite | Level 9

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.

Madelyn_SAS
SAS Super FREQ

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.

sas-innovate-2024.png

 

Time is running out to save with the early bird rate. Register by Friday, March 1 for just $695 - $100 off the standard rate.

 

Check out the agenda and get ready for a jam-packed event featuring workshops, super demos, breakout sessions, roundtables, inspiring keynotes and incredible networking events. 

 

Register now!

How to Concatenate Values

Learn how use the CAT functions in SAS to join values from multiple variables into a single value.

Find more tutorials on the SAS Users YouTube channel.

Click image to register for webinarClick image to register for webinar

Classroom Training Available!

Select SAS Training centers are offering in-person courses. View upcoming courses for:

View all other training opportunities.

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