I have a dataset that include 179 countries. However, i only want to keep 51 of them (Subsaharan Africa). When i run the "keep if var == ..." im not able to run it with all the countries at once. Is there an efficient way to only keep the 51 countries?
Dataex:
Code:
* Example generated by -dataex-. For more info, type help dataex clear input str32 country_name double(country_id year v2csreprss v2csantimv) "Mexico" 3 2020 1.09 -1.512 "Suriname" 4 2020 1.935 -.6 "Sweden" 5 2020 3.085 -.769 "Switzerland" 6 2020 2.812 -2.439 "Ghana" 7 2020 2.012 -.387 "South Africa" 8 2020 1.241 -.306 "Japan" 9 2020 2.92 -1.899 "Burma/Myanmar" 10 2020 1.199 .294 "Russia" 11 2020 -.562 -.157 "Albania" 12 2020 1.359 .343 "Egypt" 13 2020 -1.355 -.233 "Yemen" 14 2020 -.87 .753 "Colombia" 15 2020 1.171 .559 "Poland" 17 2020 .775 0 "Brazil" 19 2020 1.351 -.334 "United States of America" 20 2020 1.841 .016 "Portugal" 21 2020 2.821 -.498 "El Salvador" 22 2020 .539 -1.337 "Bangladesh" 24 2020 -.233 -1.3 "Bolivia" 25 2020 .375 1.197 "Haiti" 26 2020 .109 1.404 "Honduras" 27 2020 1.798 .028 "Mali" 28 2020 .943 1.579 "Pakistan" 29 2020 -.201 -.079 "Peru" 30 2020 1.649 -.763 "Senegal" 31 2020 1.696 .202 "South Sudan" 32 2020 -.814 .817 "Sudan" 33 2020 .765 -.301 "Vietnam" 34 2020 -.737 -.605 "Afghanistan" 36 2020 1.358 .975 "Argentina" 37 2020 1.89 -.465 "Ethiopia" 38 2020 .517 -.366 "India" 39 2020 -1.026 .048 "Kenya" 40 2020 .352 -1.189 "North Korea" 41 2020 -3.705 -2.65 "South Korea" 42 2020 2.537 -1.308 "Kosovo" 43 2020 1.509 -.33 "Lebanon" 44 2020 .737 1.381 "Nigeria" 45 2020 .556 1.969 "Philippines" 46 2020 .227 .734 "Tanzania" 47 2020 .396 -.807 "Taiwan" 48 2020 2.251 -.362 "Thailand" 49 2020 -1.462 2.75 "Uganda" 50 2020 -1.079 -.36 "Venezuela" 51 2020 -1.045 .814 "Benin" 52 2020 .86 -.135 "Bhutan" 53 2020 1.187 -2.214 "Burkina Faso" 54 2020 1.619 .653 "Cambodia" 55 2020 -1.14 -1.056 "Indonesia" 56 2020 .934 .059 "Mozambique" 57 2020 .356 -.205 "Nepal" 58 2020 1.207 -.419 "Nicaragua" 59 2020 -1.571 .113 "Niger" 60 2020 .739 .712 "Zambia" 61 2020 .276 -.321 "Zimbabwe" 62 2020 -1.035 .958 "Guinea" 63 2020 .153 2.336 "Ivory Coast" 64 2020 .544 .647 "Mauritania" 65 2020 .202 .619 "Canada" 66 2020 2.048 -.56 "Australia" 67 2020 1.864 -2.251 "Botswana" 68 2020 2.159 -.888 "Burundi" 69 2020 -1.849 -.277 "Cape Verde" 70 2020 2.886 -1.6 "Central African Republic" 71 2020 -.505 1.088 "Chile" 72 2020 1.469 -.713 "Costa Rica" 73 2020 2.468 -1.278 "Timor-Leste" 74 2020 2.323 .095 "Ecuador" 75 2020 .348 -.593 "France" 76 2020 1.422 -.306 "Germany" 77 2020 3.013 -.911 "Guatemala" 78 2020 .477 -.682 "Iran" 79 2020 -1.574 .186 "Iraq" 80 2020 -.099 1.069 "Ireland" 81 2020 2.977 -1.236 "Italy" 82 2020 2.755 -1.263 "Jordan" 83 2020 .183 -1.207 "Latvia" 84 2020 2.64 -.722 "Lesotho" 85 2020 1.443 -1.2 "Liberia" 86 2020 1.911 -.459 "Malawi" 87 2020 1.363 -.523 "Maldives" 88 2020 1.405 -.4 "Mongolia" 89 2020 1.333 -2.206 "Morocco" 90 2020 -.528 .475 "Netherlands" 91 2020 1.99 -.699 "Panama" 92 2020 1.716 -1.086 "Papua New Guinea" 93 2020 1.971 -1.476 "Qatar" 94 2020 -.508 -3.244 "Sierra Leone" 95 2020 2.166 -.955 "Spain" 96 2020 2.923 .014 "Syria" 97 2020 -1.961 .792 "Tunisia" 98 2020 1.955 .394 "Turkey" 99 2020 -1.521 .369 "Ukraine" 100 2020 1.744 -.093 "United Kingdom" 101 2020 2.222 -.924 "Uruguay" 102 2020 1.261 -2.131 "Algeria" 103 2020 -1.149 1.321 "Angola" 104 2020 -.19 -.001 "Armenia" 105 2020 2.324 -.527 "Azerbaijan" 106 2020 -1.271 -.534 end
Kind Regards
Carlos
0 Response to Keep multiple observations in a variable
Post a Comment