topic Re: GROUP BY and WHERE clause in SAS Programming https://communities.sas.com/t5/SAS-Programming/GROUP-BY-and-WHERE-clause/m-p/804961#M317047 <P>Please do NOT remove your post after it's been answered.</P> Wed, 30 Mar 2022 06:25:40 GMT ChrisNZ 2022-03-30T06:25:40Z GROUP BY and WHERE clause https://communities.sas.com/t5/SAS-Programming/GROUP-BY-and-WHERE-clause/m-p/804912#M317008 Wed, 30 Mar 2022 04:00:02 GMT https://communities.sas.com/t5/SAS-Programming/GROUP-BY-and-WHERE-clause/m-p/804912#M317008 anonymous_user 2022-03-30T04:00:02Z Re: GROUP BY and WHERE clause https://communities.sas.com/t5/SAS-Programming/GROUP-BY-and-WHERE-clause/m-p/804918#M317011 <P><span class="lia-inline-image-display-wrapper lia-image-align-inline" image-alt="Patrick_0-1648598686047.png" style="width: 641px;"><img src="https://communities.sas.com/t5/image/serverpage/image-id/69942i67C64CC6A7D90ECF/image-dimensions/641x197?v=v2" width="641" height="197" role="button" title="Patrick_0-1648598686047.png" alt="Patrick_0-1648598686047.png" /></span></P> <P>1. If eventDate is a SAS Date value then you need to provide the boundary values as SAS Date values and not as strings.</P> <PRE>and eventDate between "01dec2020"d and "31dec2021"d</PRE> <P>2. There shouldn't be an AND before the GROUP BY clause</P> <P>&nbsp;</P> Wed, 30 Mar 2022 08:43:02 GMT https://communities.sas.com/t5/SAS-Programming/GROUP-BY-and-WHERE-clause/m-p/804918#M317011 Patrick 2022-03-30T08:43:02Z Re: GROUP BY and WHERE clause https://communities.sas.com/t5/SAS-Programming/GROUP-BY-and-WHERE-clause/m-p/804961#M317047 <P>Please do NOT remove your post after it's been answered.</P> Wed, 30 Mar 2022 06:25:40 GMT https://communities.sas.com/t5/SAS-Programming/GROUP-BY-and-WHERE-clause/m-p/804961#M317047 ChrisNZ 2022-03-30T06:25:40Z