I have to Data sets one with inflows and one with outflows and i wanna combine them to one. In the End i want to have one data set with seperate variables for Inflows and Outflows and the Value for either one of them.
do i use the merge command or maybe kountry command
Inflow Data:
The second data set looks exactly alike just with "Directional principle: Outward"
I somehow cant get it right maybe you can halpe me Stata Team!
Thank you in advance!!
do i use the merge command or maybe kountry command
Inflow Data:
Code:
* Example generated by -dataex-. For more info, type help dataex clear input str49 country str30 InwardFlow str62 partnercountry int year float value "Australia" "Directional principle: Inward" "Tanzania, United Republic of" 2013 . "Australia" "Directional principle: Inward" "Iceland" 2013 0 "Australia" "Directional principle: Inward" "El Salvador" 2013 0 "Australia" "Directional principle: Inward" "Singapore" 2013 1521.6133 "Australia" "Directional principle: Inward" "Namibia" 2013 . "Australia" "Directional principle: Inward" "OECD" 2013 41414.51 "Australia" "Directional principle: Inward" "Greece" 2013 . "Australia" "Directional principle: Inward" "Swaziland" 2013 . "Australia" "Directional principle: Inward" "EU28" 2013 11452.142 "Australia" "Directional principle: Inward" "Tuvalu" 2013 0 "Australia" "Directional principle: Inward" "Yemen" 2013 0 "Australia" "Directional principle: Inward" "United Kingdom" 2013 9973.948 "Australia" "Directional principle: Inward" "Brunei Darussalam" 2013 . "Australia" "Directional principle: Inward" "Germany" 2013 69.471245 "Australia" "Directional principle: Inward" "Benin" 2013 0 "Australia" "Directional principle: Inward" "Iraq" 2013 0 "Australia" "Directional principle: Inward" "Kyrgyzstan" 2013 0 "Australia" "Directional principle: Inward" "ODA recipients -Africa" 2013 . "Australia" "Directional principle: Inward" "Total Official Development Assistance (ODA) recipients" 2013 . "Australia" "Directional principle: Inward" "Zambia" 2013 . "Australia" "Directional principle: Inward" "Guinea-Bissau" 2013 0 "Australia" "Directional principle: Inward" "Virgin Islands, U.S." 2013 0 "Australia" "Directional principle: Inward" "Turks and Caicos Islands" 2013 0 "Australia" "Directional principle: Inward" "Kuwait" 2013 . "Australia" "Directional principle: Inward" "MENA countries" 2013 . "Australia" "Directional principle: Inward" "French Polynesia" 2013 . "Australia" "Directional principle: Inward" "Other territories" 2013 0 "Australia" "Directional principle: Inward" "Ireland" 2013 475.6851 "Australia" "Directional principle: Inward" "Macao" 2013 . "Australia" "Directional principle: Inward" "Nepal" 2013 0 "Australia" "Directional principle: Inward" "Chile" 2013 . "Australia" "Directional principle: Inward" "Gambia" 2013 0 "Australia" "Directional principle: Inward" "Cook Islands" 2013 . "Australia" "Directional principle: Inward" "Viet Nam" 2013 2.894635 "Australia" "Directional principle: Inward" "Pitcairn" 2013 0 "Australia" "Directional principle: Inward" "Côte d'Ivoire" 2013 . "Australia" "Directional principle: Inward" "Lithuania" 2013 0 "Australia" "Directional principle: Inward" "Kenya" 2013 . "Australia" "Directional principle: Inward" "Nicaragua" 2013 0 "Australia" "Directional principle: Inward" "Colombia" 2013 . "Australia" "Directional principle: Inward" "Paraguay" 2013 0 "Australia" "Directional principle: Inward" "Qatar" 2013 . "Australia" "Directional principle: Inward" "Brazil" 2013 .9648784 "Australia" "Directional principle: Inward" "Somalia" 2013 0 "Australia" "Directional principle: Inward" "Andorra" 2013 0 "Australia" "Directional principle: Inward" "Bahrain" 2013 . "Australia" "Directional principle: Inward" "France" 2013 -1124.0834 "Australia" "Directional principle: Inward" "Jordan" 2013 . "Australia" "Directional principle: Inward" "Ecuador" 2013 0 "Australia" "Directional principle: Inward" "Belarus" 2013 0 "Australia" "Directional principle: Inward" "Libya" 2013 0 "Australia" "Directional principle: Inward" "US Minor Outlying islands" 2013 0 "Australia" "Directional principle: Inward" "Slovenia" 2013 . "Australia" "Directional principle: Inward" "Liberia" 2013 . "Australia" "Directional principle: Inward" "Niue" 2013 0 "Australia" "Directional principle: Inward" "Uzbekistan" 2013 0 "Australia" "Directional principle: Inward" "Dominica" 2013 0 "Australia" "Directional principle: Inward" "Mexico" 2013 0 "Australia" "Directional principle: Inward" "American Samoa" 2013 . "Australia" "Directional principle: Inward" "Saint Lucia" 2013 0 "Australia" "Directional principle: Inward" "Comoros" 2013 0 "Australia" "Directional principle: Inward" "Oman" 2013 . "Australia" "Directional principle: Inward" "Palau" 2013 0 "Australia" "Directional principle: Inward" "ODA recipients-America" 2013 . "Australia" "Directional principle: Inward" "Cuba" 2013 0 "Australia" "Directional principle: Inward" "Estonia" 2013 0 "Australia" "Directional principle: Inward" "Saint Helena" 2013 0 "Australia" "Directional principle: Inward" "Tunisia" 2013 . "Australia" "Directional principle: Inward" "Faroe Islands" 2013 0 "Australia" "Directional principle: Inward" "Hong Kong, China" 2013 1057.5067 "Australia" "Directional principle: Inward" "Guernsey" 2013 . "Australia" "Directional principle: Inward" "Korea, Republic of (South Korea)" 2013 532.6129 "Australia" "Directional principle: Inward" "Guam" 2013 0 "Australia" "Directional principle: Inward" "Ukraine" 2013 0 "Australia" "Directional principle: Inward" "Italy" 2013 . "Australia" "Directional principle: Inward" "WORLD" 2013 56734.85 "Australia" "Directional principle: Inward" "Senegal" 2013 . "Australia" "Directional principle: Inward" "Jamaica" 2013 0 "Australia" "Directional principle: Inward" "Sri Lanka" 2013 . "Australia" "Directional principle: Inward" "Montenegro" 2013 0 "Australia" "Directional principle: Inward" "Congo" 2013 . "Australia" "Directional principle: Inward" "Seychelles" 2013 0 "Australia" "Directional principle: Inward" "Azerbaijan" 2013 0 "Australia" "Directional principle: Inward" "Sweden" 2013 52.10344 "Australia" "Directional principle: Inward" "South Sudan" 2013 0 "Australia" "Directional principle: Inward" "Sudan" 2013 0 "Australia" "Directional principle: Inward" "Uruguay" 2013 0 "Australia" "Directional principle: Inward" "China" 2013 5937.862 "Australia" "Directional principle: Inward" "Belgium" 2013 998.6492 "Australia" "Directional principle: Inward" "Gabon" 2013 . "Australia" "Directional principle: Inward" "Georgia" 2013 0 "Australia" "Directional principle: Inward" "Finland" 2013 . "Australia" "Directional principle: Inward" "United Arab Emirates" 2013 . "Australia" "Directional principle: Inward" "Romania" 2013 0 "Australia" "Directional principle: Inward" "Saint Kitts and Nevis" 2013 0 "Australia" "Directional principle: Inward" "Israel" 2013 0 "Australia" "Directional principle: Inward" "Trinidad and Tobago" 2013 0 "Australia" "Directional principle: Inward" "Bulgaria" 2013 . "Australia" "Directional principle: Inward" "Antarctica" 2013 0 "Australia" "Directional principle: Inward" "Turkmenistan" 2013 0 end
I somehow cant get it right maybe you can halpe me Stata Team!
Thank you in advance!!
Comment