I am having a dataset of some indicators for countries over years. Below is an example of the dataset
Code:
* Example generated by -dataex-. To install: ssc install dataex clear input str11 country int year byte(var1 var2 var3) "South Korea" 2011 . 92 19 "South Korea" 2012 24 41 . "South Korea" 2013 . 37 43 "South Korea" 2014 54 82 . "South Korea" 2015 17 53 . "Syria" 2011 63 45 58 "Syria" 2012 . 67 . "Syria" 2013 41 85 20 "Syria" 2014 12 15 41 "Syria" 2015 58 18 . "Taiwan" 2011 45 15 53 "Taiwan" 2012 78 78 . "Taiwan" 2013 42 36 64 "Taiwan" 2014 69 52 . "Taiwan" 2015 . 48 85 "Venezuela" 2011 15 91 25 "Venezuela" 2012 26 48 . "Venezuela" 2013 36 . 63 "Venezuela" 2014 41 . . "Venezuela" 2015 20 . 74 end
My goal is to collapse the dataset with the latest value for each variable.
Thanks in advance
0 Response to Collapsing dataset with only the latest value for each variable
Post a Comment