Hi Everyone,     I am trying to find the average of the final 5 years of the VALUE column for each country.    I am working with the below data and the code that I have developed thus far is shown below.   The problem I face is that it is calculating the average of all years, rather than just the last 5.   I have tried to correct this by defining a start year but it doesn't seem to be working.   Does anyone have suggestions on how I can calculate the average of the final 5 values in each by group using the code I have thus far as a starting point.   All help is very much appreciated. /*DECLARE START YEAR*/ %let startyear = 2018; data year; input COUNTRY$ YEAR VALUE; datalines; SPAIN 2016 10 SPAIN 2017 11 SPAIN 2018 13 SPAIN 2019 12 SPAIN 2020 15 SPAIN 2021 16 SPAIN 2022 11 Germany 2016 12 Germany 2017 18 Germany 2018 21 Germany 2019 13 Germany 2020 12 Germany 2021 12 Germany 2022 13 ; run; PROC SORT DATA=year OUT=Sorted; BY Country; RUN; DATA average; set Sorted; by country year; if (first.country and year = &startyear) then do; y = 0; n = 0; end; n + 1; y + value; avg = y/n; run; ... View more

Kurt,   I cannot thank you enough!   I have been working with your code for the past hour and it is working a treat!   I had spent quite a long time working through different approaches to find a solution  and the method that you have provided will prove to be very useful for the future projects. I hope that the code that you have provided is of help to many other users.   Thank you very much for all of your time on this. All of the help is highly appreciated!   Best Wishes!   ML  ... View more