Hello everyone, I'm trying to count a variable called "EI_D" that values 1 for last 5 years. Here is my dataset. Year Code EI_D 2010 A 1 2011 A 0 2012 A 1 2013 A 1 2014 A 0 2015 A 1 2016 A 0 2017 A 0 2018 A 1 2014 B 1 2015 B 1 2016 B 0 2017 B 1 2018 B 0 I want my dataset looking like below. Year Code EI_D Count 2010 A 1 2011 A 0 2012 A 1 2013 A 1 2014 A 0 3 2015 A 1 3 (Since I want to count EI_D that is 1 for last 5 years, I do not include 2010) 2016 A 0 3 2017 A 0 2 2018 A 1 2 2014 B 1 2015 B 1 2016 B 0 2017 B 1 2018 B 0 3 I tried several types of PROC SQL code but they didn't work for me. I truly appreciate everyone's help...
... View more