Replace missing value with many subgroup
Hello! 

Countries Year Value
Malaysia 2015 1
Malaysia 2014 2
Malaysia 2013 3
Malaysia 2012 4
Malaysia 2011 ?
Malaysia 2010 ?
Malaysia 2009 7
Malaysia 2008 ?
Malaysia 2007 8
Malaysia 2006 9
Malaysia 2005 10
Malaysia 2004 ?
Indonesia 2015 1
Indonesia 2014 2
Indonesia 2013 3
Indonesia 2012 ?
Indonesia 2011 5
Indonesia 2010 6
Indonesia 2009 7
Indonesia 2008 ?
Indonesia 2007 8
Indonesia 2006 9
Indonesia 2005 10
Indonesia 2004 ?
I want to find the average of all countries, I have 190+ countries, but when I use the replace missing value operator, it divides the value by all countries' values, which is not accurate. How I can find the average of all countries by only dividing the particular countries?
Exp:
Malaysia =(1+2+3+4+7+8+9+10)/8
Here is my dataset, thanks for helping me!
