Hello! I would like to know how to drop observations for countries that only have observations in the variable greenhouse. Sorry if it sounds vague, not sure how to properly phrase it!
Code:
* Example generated by -dataex-. For more info, type help dataex clear input str52 country str3 code int year double(greenhouse population gdp) float(pve rle) "Afghanistan" "AFG" 1996 17106595 17106595 . -2.4173095 -1.7880754 "Afghanistan" "AFG" 1997 17788819 . . . . "Afghanistan" "AFG" 1998 18493132 18493132 . -2.4273546 -1.7348868 "Afghanistan" "AFG" 1999 19262847 . . . . "Afghanistan" "AFG" 2000 19542982 19542982 . -2.438969 -1.7806607 "Afghanistan" "AFG" 2001 19688632 . . . . "Afghanistan" "AFG" 2002 21000256 21000256 183.53277523720223 -2.0350337 -1.6734732 "Afghanistan" "AFG" 2003 22645130 22645130 200.46256674383832 -2.1983724 -1.5582937 "Afghanistan" "AFG" 2004 23553551 23553551 221.6576041829469 -2.2956822 -1.6939253 "Afghanistan" "AFG" 2005 24411191 24411191 255.05511997846034 -2.06751 -1.6629655 "Afghanistan" "AFG" 2006 25442944 25442944 274.00048647134827 -2.2191346 -1.879005 "Afghanistan" "AFG" 2007 25903301 25903301 375.0781280653931 -2.4133735 -1.85256 "Afghanistan" "AFG" 2008 26427199 26427199 387.84917430004737 -2.691361 -1.9033076 "Afghanistan" "AFG" 2009 27385307 27385307 443.84515053633174 -2.7114215 -1.8761188 "Afghanistan" "AFG" 2010 28189672 28189672 554.5952002223537 -2.579152 -1.870058 "Afghanistan" "AFG" 2011 29249157 29249157 621.9123108615917 -2.50206 -1.9225 "Afghanistan" "AFG" 2012 30466479 30466479 663.1410528109367 -2.4185615 -1.651893 "Afghanistan" "AFG" 2013 31541209 31541209 651.9878619481084 -2.519349 -1.6091115 "Afghanistan" "AFG" 2014 32716210 32716210 628.1468038884957 -2.4110684 -1.4370445 "Afghanistan" "AFG" 2015 33753499 33753499 592.4765374516808 -2.571222 -1.4984924 "Afghanistan" "AFG" 2016 34636207 34636207 520.2520640311508 -2.671054 -1.5123806 "Afghanistan" "AFG" 2017 35643418 35643418 530.1498308029836 -2.801084 -1.5775956 "Afghanistan" "AFG" 2018 36686784 36686784 502.05677062297264 -2.763864 -1.6813577 "Afghanistan" "AFG" 2019 37769499 37769499 500.5226641452942 -2.655531 -1.7278944 "Afghanistan" "AFG" 2020 38972230 38972230 516.8665521826961 -2.70503 -1.8198975 "Afghanistan" "AFG" 2021 40099462 40099462 368.7546141754591 -2.529855 -1.871436 "Africa Eastern and Southern" "AFE" 1996 362985802 . . . . "Africa Eastern and Southern" "AFE" 1997 372352230 . . . . "Africa Eastern and Southern" "AFE" 1998 381715600 . . . . "Africa Eastern and Southern" "AFE" 1999 391486231 . . . . "Africa Eastern and Southern" "AFE" 2000 401600588 . . . . "Africa Eastern and Southern" "AFE" 2001 412001885 . . . . "Africa Eastern and Southern" "AFE" 2002 422741118 . . . . "Africa Eastern and Southern" "AFE" 2003 433807484 . . . . "Africa Eastern and Southern" "AFE" 2004 445281555 . . . . "Africa Eastern and Southern" "AFE" 2005 457153837 . . . . "Africa Eastern and Southern" "AFE" 2006 469508516 . . . . "Africa Eastern and Southern" "AFE" 2007 482406426 . . . . "Africa Eastern and Southern" "AFE" 2008 495748900 . . . . "Africa Eastern and Southern" "AFE" 2009 509410477 . . . . "Africa Eastern and Southern" "AFE" 2010 523459657 . . . . "Africa Eastern and Southern" "AFE" 2011 537792950 . . . . "Africa Eastern and Southern" "AFE" 2012 552530654 . . . . "Africa Eastern and Southern" "AFE" 2013 567891875 . . . . "Africa Eastern and Southern" "AFE" 2014 583650827 . . . . "Africa Eastern and Southern" "AFE" 2015 600008150 . . . . "Africa Eastern and Southern" "AFE" 2016 616377331 . . . . "Africa Eastern and Southern" "AFE" 2017 632746296 . . . . "Africa Eastern and Southern" "AFE" 2018 649756874 . . . . "Africa Eastern and Southern" "AFE" 2019 667242712 . . . . "Africa Eastern and Southern" "AFE" 2020 685112705 . . . . "Africa Eastern and Southern" "AFE" 2021 702976832 . . . . "Africa Western and Central" "AFW" 1996 242200260 . . . . "Africa Western and Central" "AFW" 1997 248713095 . . . . "Africa Western and Central" "AFW" 1998 255482918 . . . . "Africa Western and Central" "AFW" 1999 262397030 . . . . "Africa Western and Central" "AFW" 2000 269611898 . . . . "Africa Western and Central" "AFW" 2001 277160097 . . . . "Africa Western and Central" "AFW" 2002 284952322 . . . . "Africa Western and Central" "AFW" 2003 292977949 . . . . "Africa Western and Central" "AFW" 2004 301265247 . . . . "Africa Western and Central" "AFW" 2005 309824829 . . . . "Africa Western and Central" "AFW" 2006 318601484 . . . . "Africa Western and Central" "AFW" 2007 327612838 . . . . "Africa Western and Central" "AFW" 2008 336893835 . . . . "Africa Western and Central" "AFW" 2009 346475221 . . . . "Africa Western and Central" "AFW" 2010 356337762 . . . . "Africa Western and Central" "AFW" 2011 366489204 . . . . "Africa Western and Central" "AFW" 2012 376797999 . . . . "Africa Western and Central" "AFW" 2013 387204553 . . . . "Africa Western and Central" "AFW" 2014 397855507 . . . . "Africa Western and Central" "AFW" 2015 408690375 . . . . "Africa Western and Central" "AFW" 2016 419778384 . . . . "Africa Western and Central" "AFW" 2017 431138704 . . . . "Africa Western and Central" "AFW" 2018 442646825 . . . . "Africa Western and Central" "AFW" 2019 454306063 . . . . "Africa Western and Central" "AFW" 2020 466189102 . . . . "Africa Western and Central" "AFW" 2021 478185907 . . . . "Albania" "ALB" 1996 3168033 3168033 1009.9772748382063 -.3366251 -.6844818 "Albania" "ALB" 1997 3148281 . . . . "Albania" "ALB" 1998 3128530 3128530 813.789396580449 -.5440042 -.9296717 "Albania" "ALB" 1999 3108778 . . . . "Albania" "ALB" 2000 3089027 3089027 1126.6833401071663 -.5399896 -1.0206677 "Albania" "ALB" 2001 3060173 . . . . "Albania" "ALB" 2002 3051010 3051010 1425.1242186014215 -.29771918 -.7623214 "Albania" "ALB" 2003 3039616 3039616 1846.120120812074 -.3097802 -.7163235 "Albania" "ALB" 2004 3026939 3026939 2373.5812917005464 -.4272597 -.7010323 "Albania" "ALB" 2005 3011487 3011487 2673.7865842955907 -.505048 -.7638332 "Albania" "ALB" 2006 2992547 2992547 2972.742923997986 -.5081573 -.7031358 "Albania" "ALB" 2007 2970017 2970017 3595.038056828926 -.20397465 -.661546 "Albania" "ALB" 2008 2947314 2947314 4370.539924776899 -.030500913 -.6000793 "Albania" "ALB" 2009 2927519 2927519 4114.134899163423 -.04514051 -.4943702 "Albania" "ALB" 2010 2913021 2913021 4094.3483857449382 -.1914829 -.3857605 "Albania" "ALB" 2011 2905195 2905195 4437.142612226842 -.28237942 -.4429265 "Albania" "ALB" 2012 2900401 2900401 4247.630047481943 -.14363159 -.51983976 "Albania" "ALB" 2013 2895092 2895092 4413.062005289033 .09192979 -.518606 "Albania" "ALB" 2014 2889104 2889104 4578.633208121549 .4859862 -.3109798 "Albania" "ALB" 2015 2880703 2880703 3952.802538075274 .3461291 -.2988629 "Albania" "ALB" 2016 2876101 2876101 4124.05538986272 .3446447 -.3040184 "Albania" "ALB" 2017 2873457 2873457 4531.019373768898 .3784748 -.3950793 end
Comment