topic Re: Count by group in SAS VA in SAS Visual Analytics

Count by group in SAS VA

RedBishop — Wed, 28 Oct 2020 16:38:09 GMT

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!

Re: Count by group in SAS VA

PetriRoine — Thu, 29 Oct 2020 08:54:33 GMT

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

Re: Count by group in SAS VA

RedBishop — Fri, 30 Oct 2020 08:42:39 GMT

Thanks for the reply @PetriRoine. Too bad I'm using SAS VA version 7.4.

Assuming it's just impossible then?