GROUP BY and WHERE clause

[Patrick]

1. If eventDate is a SAS Date value then you need to provide the boundary values as SAS Date values and not as strings.

and eventDate between "01dec2020"d and "31dec2021"d

2. There shouldn't be an AND before the GROUP BY clause

[ChrisNZ]

Please do NOT remove your post after it's been answered.