Hi!
I want to find the sum of Imports to Bangladesh from the whole world (i.e. all its trading partners in the dataset) for a given year but it has to be summed over the product codes in which Bangladesh is importing from India. And this has to be done for all the years i.e. from 2009 to 2015. I have tried to find some Stata commands that pertain to the exact need of my question but couldn't. It'll be a big help if you could suggest a solution.
I am using Stata 13 and my dataset looks like this :
Code:
* Example generated by -dataex-. To install: ssc install dataex clear input str3 reporteriso3 long productcode str10 reportername str3 partneriso3 str30 partnername int year str6 tradeflowname float tradevaluein1000usd "BGD" 10110 "Bangladesh" "CHN" "China" 2009 "Import" 7.837 "BGD" 10110 "Bangladesh" "CHN" "China" 2011 "Import" .539 "BGD" 10110 "Bangladesh" "HKG" "Hong Kong, China" 2012 "Import" 1.319 "BGD" 10110 "Bangladesh" "IND" "India" 2010 "Import" 79.487 "BGD" 10110 "Bangladesh" "IND" "India" 2013 "Import" 104.402 "BGD" 10110 "Bangladesh" "SGP" "Singapore" 2012 "Import" .019 "BGD" 10110 "Bangladesh" "SGP" "Singapore" 2013 "Import" 2.759 "BGD" 10110 "Bangladesh" "THA" "Thailand" 2011 "Import" .486 "BGD" 10190 "Bangladesh" "CAN" "Canada" 2013 "Import" .154 "BGD" 10190 "Bangladesh" "HKG" "Hong Kong, China" 2013 "Import" .154 "BGD" 10190 "Bangladesh" "LKA" "Sri Lanka" 2013 "Import" .103 "BGD" 10190 "Bangladesh" "MAR" "Morocco" 2011 "Import" .103 "BGD" 10190 "Bangladesh" "MYS" "Malaysia" 2010 "Import" .142 "BGD" 10190 "Bangladesh" "USA" "United States" 2012 "Import" .256 "BGD" 10210 "Bangladesh" "AUS" "Australia" 2015 "Import" 196.766 "BGD" 10410 "Bangladesh" "MYS" "Malaysia" 2012 "Import" 7.682 "BGD" 10420 "Bangladesh" "MYS" "Malaysia" 2012 "Import" 18.91 "BGD" 10420 "Bangladesh" "ZAF" "South Africa" 2012 "Import" .185 "BGD" 10420 "Bangladesh" "ZAF" "South Africa" 2015 "Import" .41 "BGD" 10511 "Bangladesh" "AUS" "Australia" 2009 "Import" 139.329 "BGD" 10511 "Bangladesh" "AUS" "Australia" 2010 "Import" 241.696 "BGD" 10511 "Bangladesh" "AUS" "Australia" 2011 "Import" 39.662 "BGD" 10511 "Bangladesh" "AUS" "Australia" 2012 "Import" 576.722 "BGD" 10511 "Bangladesh" "AUS" "Australia" 2013 "Import" 61.002 "BGD" 10511 "Bangladesh" "DEU" "Germany" 2009 "Import" 19.958 "BGD" 10511 "Bangladesh" "DEU" "Germany" 2010 "Import" 25.19 "BGD" 10511 "Bangladesh" "DEU" "Germany" 2013 "Import" 91.38 "BGD" 10511 "Bangladesh" "FIN" "Finland" 2015 "Import" 2.322 "BGD" 10511 "Bangladesh" "FRA" "France" 2009 "Import" 788.432 "BGD" 10511 "Bangladesh" "FRA" "France" 2010 "Import" 18.792 "BGD" 10511 "Bangladesh" "FRA" "France" 2011 "Import" 352.869 "BGD" 10511 "Bangladesh" "FRA" "France" 2012 "Import" 1515.588 "BGD" 10511 "Bangladesh" "FRA" "France" 2013 "Import" 3663.748 "BGD" 10511 "Bangladesh" "FRA" "France" 2015 "Import" 2369.678 "BGD" 10511 "Bangladesh" "GBR" "United Kingdom" 2011 "Import" 394.17 "BGD" 10511 "Bangladesh" "GBR" "United Kingdom" 2012 "Import" 345.2 "BGD" 10511 "Bangladesh" "GBR" "United Kingdom" 2013 "Import" 1782.948 "BGD" 10511 "Bangladesh" "GBR" "United Kingdom" 2015 "Import" 2059.298 "BGD" 10511 "Bangladesh" "HUN" "Hungary" 2010 "Import" 23.69 "BGD" 10511 "Bangladesh" "IND" "India" 2010 "Import" 36.223 "BGD" 10511 "Bangladesh" "IND" "India" 2011 "Import" 34.629 end
