Asssuming your date variable is in a date format, you can do the following: (If your date is a character, you can create a calculated item and use the parse operator to convert the date to a date type)   Average by Month: 1. Duplicate the date variable, rename to Month Year, and change the format to 'MMMYYYY' 2. Create a calculated item 'Average Population' = Avg [by group] population' 3. Put the Month Year and Average Population in a list table and averages by month will be calculated.   Average by Fiscal Year: I would recommend adding an extra column in your data indicating which fiscal period that date falls within. For example, if one fiscal year is April 2014 - March 2015, then add an extra column where the fiscal year is 2014 for all those records. Your data should look something like this:   date population gender fiscal year 04Jan2015 395 F 2014 04Jan2015 3052 M 2014 05Apr2015 3143 M 2015 05May2015 397 F 2015 06Jan2016 405 F 2015 06May2016 3120 M 2016   Then, you can use the fiscal year variable and the same average population item created above in another list table and the averages will automatically calculate for the fiscal years.   Hope this helps, Jaime ... View more

With SAS Visual Analytics 8.5, you can use the _Full_ parameter interval to calculate over multiple years rather than year over year.       Hope this helps, Jaime ... View more