GROUP BY and WHERE clause

Not applicable

2 REPLIES 2

Opal | Level 21

Re: GROUP BY and WHERE clause

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

Tourmaline | Level 20

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