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;
... View more
Here is one way.
T3 needs to be turned around. I let you do it.
proc summary data=HAVE ;
class HOSPITAL;
var HEADACHE -- BLUR_VISION ;
output out=SUMMARY sum=;
run;
proc transpose data=SUMMARY out=TRANSPOSED;
by HOSPITAL;
run;
data T1(keep=_NAME_ NB_1 NB_0)
T2(keep=_NAME_ NB_1 PCT )
T3(keep=_NAME_ NB_1 HOSPITAL );
set TRANSPOSED ;
retain TOTAL;
if _NAME_='_FREQ_' then TOTAL=COL1;
if _NAME_ ne: '_' ;
NB_1=COL1; NB_0=TOTAL-COL1; PCT=NB_1/TOTAL;
if HOSPITAL=. then output T1 T2;
else output T3;
run;
NAME
NB_1
NB_0
HEADACHE
6
6
FEVER
7
5
BLUR_VISION
6
6
NAME
NB_1
PCT
HEADACHE
6
0.5
FEVER
7
0.583333
BLUR_VISION
6
0.5
HOSPITAL
NAME
NB_1
0
HEADACHE
2
0
FEVER
3
0
BLUR_VISION
3
1
HEADACHE
4
1
FEVER
4
1
BLUR_VISION
3
... View more
PROC EXPAND (if you have it in your SAS license) can provide 3 year moving averages of your data.
Since your output is vertical but the table you want is horizontal, you could transpose your output, then use ARRAYs in a data step to get three year moving averages.
But just a word to the wise ... keep your final table vertical, not horizontal, it's a much easier format for SAS to work with, and much easier for people to read.
... View more
