topic calculate average number of observations (rows) per month in SAS Programming https://communities.sas.com/t5/SAS-Programming/calculate-average-number-of-observations-rows-per-month/m-p/616440#M180463 <P>Hello,<BR /><BR />I have a dataset containing observations over the course of 3 years. How can I calculate the average number of observations by month? So, for instance, I have a number of observations from January 2015, 2016, and 2017. How can I calculate the 3-year average value of observations that occurred in January (and every other month)?<BR /><BR />I hope to end up with average as a separate value that I can plot on a bar chart.<BR /><BR />A small sample of my dataset is attached.&nbsp; I am basing all of my date calculations on DtSpec2.<BR /><BR />Thanks!</P> Fri, 10 Jan 2020 12:47:16 GMT jbrock 2020-01-10T12:47:16Z calculate average number of observations (rows) per month https://communities.sas.com/t5/SAS-Programming/calculate-average-number-of-observations-rows-per-month/m-p/616440#M180463 <P>Hello,<BR /><BR />I have a dataset containing observations over the course of 3 years. How can I calculate the average number of observations by month? So, for instance, I have a number of observations from January 2015, 2016, and 2017. How can I calculate the 3-year average value of observations that occurred in January (and every other month)?<BR /><BR />I hope to end up with average as a separate value that I can plot on a bar chart.<BR /><BR />A small sample of my dataset is attached.&nbsp; I am basing all of my date calculations on DtSpec2.<BR /><BR />Thanks!</P> Fri, 10 Jan 2020 12:47:16 GMT https://communities.sas.com/t5/SAS-Programming/calculate-average-number-of-observations-rows-per-month/m-p/616440#M180463 jbrock 2020-01-10T12:47:16Z Re: calculate average number of observations (rows) per month https://communities.sas.com/t5/SAS-Programming/calculate-average-number-of-observations-rows-per-month/m-p/616442#M180464 <P>This was answered in your other thread, in particular in message 16&nbsp;<A href="https://communities.sas.com/t5/Graphics-Programming/Add-average-line-to-bar-chart/m-p/615663#M19297" target="_blank">https://communities.sas.com/t5/Graphics-Programming/Add-average-line-to-bar-chart/m-p/615663#M19297</A></P> Fri, 10 Jan 2020 12:54:22 GMT https://communities.sas.com/t5/SAS-Programming/calculate-average-number-of-observations-rows-per-month/m-p/616442#M180464 PaigeMiller 2020-01-10T12:54:22Z