- Mark as New
- Bookmark
- Subscribe
- Mute
- RSS Feed
- Permalink
- Report Inappropriate Content
Posted 02-11-2015 06:08 AM
(5208 views)
Hi All,
I got the following problem:
Data looks like:
Article | Shop | Supplier | Value |
---|---|---|---|
A | 1 | SUP1 | 1 |
A | 2 | SUP1 | 1 |
A | 2 | SUP1 | 1 |
B | 2 | SUP2 | 1 |
B | 2 | SUP2 | 1 |
B | 3 | SUP2 | 1 |
B | 3 | SUP2 | 1 |
C | 3 | SUP3 | 1 |
C | 3 | SUP3 | 1 |
C | 3 | SUP3 | 1 |
C | 4 | SUP3 | 1 |
C | 4 | SUP3 | 1 |
C | 4 | SUP3 | 1 |
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?
2 REPLIES 2
- Mark as New
- Bookmark
- Subscribe
- Mute
- RSS Feed
- Permalink
- Report Inappropriate Content
ok, stupid question, i just have to use a distinct article...
- Mark as New
- Bookmark
- Subscribe
- Mute
- RSS Feed
- Permalink
- Report Inappropriate Content
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
//Contact me to learn how Metacoda software can help keep your SAS platform secure - https://www.metacoda.com