Error in proc sql group by statement

JenMMerc — Tue, 26 Oct 2021 16:44:04 GMT

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;

Re: Error in proc sql group by statement

Reeza — Tue, 26 Oct 2021 16:50:18 GMT

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;

topic Error in proc sql group by statement in New SAS User

Error in proc sql group by statement

Re: Error in proc sql group by statement