https://communities.sas.com/t5/SAS-Procedures/Average-per-month-from-daily-series/m-p/33152#M8036 Formats, to create groups. In this case MONYY.<BR /> <BR /> [pre]<BR /> data have;<BR /> input date:date. y;<BR /> format date date9.;<BR /> cards;<BR /> 26-Oct-09 1.065<BR /> 27-Oct-09 1.063<BR /> 28-Oct-09 1.082<BR /> 29-Oct-09 1.068<BR /> 30-Oct-09 1.08<BR /> 02-Nov-09 1.07<BR /> 03-Nov-09 1.06<BR /> 04-Nov-09 1.062<BR /> ;;;;<BR /> run;<BR /> proc means;<BR /> class date;<BR /> format date monyy.;<BR /> run;<BR /> [/pre] Mon, 21 Dec 2009 13:00:00 GMT data_null__ 2009-12-21T13:00:00Z https://communities.sas.com/t5/SAS-Procedures/Average-per-month-from-daily-series/m-p/33151#M8035 How could I calculate out a daily series a monthly average. For example<BR /> <BR /> 26-Oct-09 1.065<BR /> 27-Oct-09 1.063<BR /> 28-Oct-09 1.082<BR /> 29-Oct-09 1.068<BR /> 30-Oct-09 1.08<BR /> 02-Nov-09 1.07<BR /> 03-Nov-09 1.06<BR /> 04-Nov-09 1.062<BR /> <BR /> How to get the monthly average of these (for Oct 09 and Nov 09).<BR /> Thanks for your help. Mon, 21 Dec 2009 12:45:38 GMT https://communities.sas.com/t5/SAS-Procedures/Average-per-month-from-daily-series/m-p/33151#M8035 coba 2009-12-21T12:45:38Z https://communities.sas.com/t5/SAS-Procedures/Average-per-month-from-daily-series/m-p/33152#M8036 Formats, to create groups. In this case MONYY.<BR /> <BR /> [pre]<BR /> data have;<BR /> input date:date. y;<BR /> format date date9.;<BR /> cards;<BR /> 26-Oct-09 1.065<BR /> 27-Oct-09 1.063<BR /> 28-Oct-09 1.082<BR /> 29-Oct-09 1.068<BR /> 30-Oct-09 1.08<BR /> 02-Nov-09 1.07<BR /> 03-Nov-09 1.06<BR /> 04-Nov-09 1.062<BR /> ;;;;<BR /> run;<BR /> proc means;<BR /> class date;<BR /> format date monyy.;<BR /> run;<BR /> [/pre] Mon, 21 Dec 2009 13:00:00 GMT https://communities.sas.com/t5/SAS-Procedures/Average-per-month-from-daily-series/m-p/33152#M8036 data_null__ 2009-12-21T13:00:00Z