- Mark as New
- Bookmark
- Subscribe
- Mute
- RSS Feed
- Permalink
- Report Inappropriate Content
Posted 10-28-2020 12:38 PM
(2424 views)
Dear SAS VA community,
From the columns "Have", I am trying to generate a calculated item "Want": = the count of Have.
Have | Want (=calculated item) |
A | 4 |
A | 4 |
A | 4 |
A | 4 |
B | 3 |
B | 3 |
B | 3 |
Is there an easy way to do this in SAS VA? "Want" needs to be dynamic, so I can't do it in SAS EG.
Thanks in advance!
2 REPLIES 2
- Mark as New
- Bookmark
- Subscribe
- Mute
- RSS Feed
- Permalink
- Report Inappropriate Content
Hello @RedBishop ,
Which version of VA you are using? One way to achieve this in VA8.3 onwards is by creating Aggregated Data Source (Selected items: Have + Frequency) from the original data source. Then utilize New data from join to join the aggregated frequency back to original data.
Best regards,
Petri
- Mark as New
- Bookmark
- Subscribe
- Mute
- RSS Feed
- Permalink
- Report Inappropriate Content
Thanks for the reply @PetriRoine. Too bad I'm using SAS VA version 7.4.
Assuming it's just impossible then?