Count by group in SAS VA

[RedBishop]

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!

[PetriRoine]

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

[RedBishop]

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

Assuming it's just impossible then?