Exploring, modeling, predicting and reporting with SAS Visual Analytics and SAS Visual Statistics

SAS VA report : specific distinct count - is it possible?

Reply
Regular Contributor
Posts: 225

SAS VA report : specific distinct count - is it possible?

Hi All,

I got the following problem:

Data looks like:

ArticleShopSupplierValue
A1SUP11
A2SUP11
A2SUP11
B2SUP21
B2SUP21
B3SUP21
B3SUP21
C3SUP31
C3SUP31
C3SUP31
C4SUP31
C4SUP31
C4SUP31

I want to report to count the values for each Supplier, but only select for the distinct (Article, Shop) combinations.

Is this possible in VA?

Regular Contributor
Posts: 225

Re: SAS VA report : specific distinct count - is it possible?

ok, stupid question, i just have to use a distinct article...

Super User
Posts: 1,209

Re: SAS VA report : specific distinct count - is it possible?

You can create a new data item as a Distinct Count on your Article data item as described in the SAS(R) Visual Analytics 7.1: User's Guide - Working with Data Items

Let us know if this helps. If not, please provide a report/table of what you expect as your end result.

Kind Regards,

Michelle

Post a Question
Discussion Stats
  • 2 replies
  • 630 views
  • 0 likes
  • 2 in conversation