Error in proc sql group by statement

[JenMMerc]

Good morning,

I am trying to create a table of summed variables grouped by date. When I run the code I receive the error:

I can't see where the problem is occurring. What am I missing? Thanks in advance.

PROC SQL;
CREATE TABLE new_table AS
SELECT Date, SUM (Fully_vaccinated) as fullvax_persons, SUM (Unvaccinated) as unvax_persons
Group BY Date
FROM denominator
WHERE Age in (12,13,14,15,16,17);
QUIT;

[Reeza · Accepted solution]

FROM & WHERE should be before GROUP.

PROC SQL;
CREATE TABLE new_table AS
SELECT Date, SUM (Fully_vaccinated) as fullvax_persons, SUM (Unvaccinated) as unvax_persons
FROM denominator
WHERE Age in (12,13,14,15,16,17)
Group BY Date;
QUIT;