Hello, When I run this code, (/* Next get mean for each month */ proc summary data=find_month nway; var what_month; output out=_mean_ mean=mean_count; run;) I end up with a dataset consisting of 1 observation. Shouldn't I end up wtih 12 observations, since I am looking for average for each month? Also, the following section: ( /* Combine means and counts */ proc sql; create table _counts1_ as select c.*,m.mean_count from _counts_ as c left join _mean_ as m on month(c.dtspec2)=m.what_month order by c.dtspec2; quit;) returns an error message saying : " ERROR: Column dtspec2 could not be found in the table/view identified with the correlation name C. ERROR: Column dtspec2 could not be found in the table/view identified with the correlation name C. ERROR: Column dtspec2 could not be found in the table/view identified with the correlation name C. ERROR: Column what_month could not be found in the table/view identified with the correlation name M. ERROR: Column what_month could not be found in the table/view identified with the correlation name M. ERROR: Column what_month could not be found in the table/view identified with the correlation name M. ERROR: Column dtspec2 could not be found in the table/view identified with the correlation name C. ERROR: Function MONTH requires a numeric expression as argument 1.
... View more