That would need some clarification,
date no_of_births
1/1 1482
1/2 1213
1/3 1220
What type is date, as 1/1 is not a date. Is it a SAS numeric date variable, i.e. 01JAN2016 for example? Is no_of_births a numeric variable? For example:
data have;
date="01JAN2016"d; no_of_births=1482; output;
date="02JAN2016"d; no_of_births=1213; output;
run;
proc sql;
create table WANT as
select distinct
month(DATE) as MON,
sum(NO_OF_BIRTHS) as NUMBER_OF_BIRTHS
from HAVE
group by month(DATE);
quit;
... View more
