Hi ,
I want to count the number of people who took a vaccine in a particular year when they have multiple years. This is what I have.
![data.PNG data.PNG](https://communities.sas.com/t5/image/serverpage/image-id/72414i63CDA7A09261A04D/image-size/large?v=v2&px=999)
So if I want the number of people who took a vaccine in Year 2017, that's going to be 2, that is patient with Id L001 and L005. If a patient took two different vaccines in the same year (for eg. L002), we count it just once (I know that's obvious). This is what I want
![want.PNG want.PNG](https://communities.sas.com/t5/image/serverpage/image-id/72415i665E3963AAF4BC76/image-size/large?v=v2&px=999)
Thank you