Goodmorning, I'm begginner on stata, I want to summarize my dataset dividing the results according to the one specific dummy variable and visualize the results in a unique tabel.
I typed the following code
but it gives me two different table but I want result displaied only in one like in this picture 
. dataex CountryName Time Lendinginterestrate IMFinterv PressFreedomIndex Fertilityrate Lifeexpectancy
----------------------- copy starting from the next line -----------------------
I hope I was clear
Thank you for your attention.
I typed the following code
Code:
sum if IMFinterv==0 sum if IMFinterv==1
. dataex CountryName Time Lendinginterestrate IMFinterv PressFreedomIndex Fertilityrate Lifeexpectancy
----------------------- copy starting from the next line -----------------------
Code:
* Example generated by -dataex-. To install: ssc install dataex clear input str24 CountryName int Time double Lendinginterestrate byte IMFinterv double(PressFreedomIndex Fertilityrate Lifeexpectancy) "Albania" 2001 196541666666667 0 . 2.068 74288 "Albania" 2002 153041666666667 1 6.5 1.981 7457899999999999 "Albania" 2003 142708333333333 1 11.5 1.897 74828 "Albania" 2004 117615218344487 1 14.17 1.821 75039 "Albania" 2005 13075 1 18 1.755 7522799999999999 "Albania" 2006 129399428618515 1 25.5 1.704 75423 "Albania" 2007 140996227871662 1 16 1.671 75646 "Albania" 2008 130196427128802 1 21.75 1.654 7591200000000001 "Albania" 2009 126609351537225 1 21.5 1.652 76221 "Albania" 2010 128223298853561 0 . 1.66 76562 "Albania" 2011 124320985987679 0 . 1.673 76914 "Albania" 2012 108803465425902 0 30.88 1.684 77252 "Albania" 2013 98266043443155 0 29.92 1.69 77554 "Albania" 2014 79725 1 28.77 1.688 77813 "Albania" 2015 78775 1 29.92 1.677 7802500000000001 "Albania" 2016 673416666666667 1 . 1.659 78194 "Albania" 2017 622 1 29.92 1.638 78333 "Albania" 2018 59325 0 29.49 1.617 78458 "Albania" 2019 627583333333333 0 29.84 1.597 7857299999999999 "Albania" 2020 612083333333333 0 . . . "Algeria" 2001 95 0 31 2.438 71116 "Algeria" 2002 858333333333333 0 33 2.403 71605 "Algeria" 2003 8125 0 43.5 2.405 72101 "Algeria" 2004 8 0 40.33 2.438 7259399999999999 "Algeria" 2005 8 0 40 2.496 73072 "Algeria" 2006 8 0 40.5 2.569 73521 "Algeria" 2007 8 0 31.33 2.649 7393600000000001 "Algeria" 2008 8 0 49.56 2.728 7431100000000001 "Algeria" 2009 8 0 47.33 2.799 7464400000000001 "Algeria" 2010 8 0 . 2.86 74938 "Algeria" 2011 8 0 . 2.909 75199 "Algeria" 2012 8 0 36.54 2.952 7543600000000001 "Algeria" 2013 8 0 36.26 2.99 75661 "Algeria" 2014 8 0 36.63 3.022 75878 "Algeria" 2015 8 0 41.69 3.043 7609 "Algeria" 2016 8 0 . 3.052 76298 "Algeria" 2017 8 0 42.83 3.045 76499 "Algeria" 2018 8 0 43.13 3.023 76693 "Algeria" 2019 8 0 45.75 2.988 7688 "Algeria" 2020 8 0 . . . "Argentina" 2001 . 0 12 2.512 73755 "Argentina" 2002 . 0 15.17 2.486 73932 "Argentina" 2003 . 1 35.826 2.461 74107 "Argentina" 2004 . 1 13.67 2.438 7428 "Argentina" 2005 . 1 17.3 2.416 7445099999999999 "Argentina" 2006 . 1 24.83 2.397 7462 "Argentina" 2007 . 0 14.08 2.38 7478700000000001 "Argentina" 2008 . 0 11.33 2.366 74952 "Argentina" 2009 . 0 16.35 2.355 75116 "Argentina" 2010 105575 0 . 2.346 7527800000000001 "Argentina" 2011 140875 0 . 2.338 7543899999999999 "Argentina" 2012 140608333333333 0 25.67 2.33 75598 "Argentina" 2013 171491666666667 0 25.27 2.322 75756 "Argentina" 2014 240091666666667 0 26.11 2.312 75913 "Argentina" 2015 249158333333333 0 25.09 2.301 76068 "Argentina" 2016 312325 0 . 2.288 76221 "Argentina" 2017 265808333333333 0 25.07 2.275 76372 "Argentina" 2018 485166666666667 1 26.05 2.261 7652 "Argentina" 2019 6725416666666671 1 28.3 2.247 76667 "Argentina" 2020 293875 1 . . . "Bahamas, The" 2001 6 0 . 1.993 7195399999999999 "Bahamas, The" 2002 6 0 . 1.931 71977 "Bahamas, The" 2003 6 0 . 1.889 71986 "Bahamas, The" 2004 6 0 . 1.867 71988 "Bahamas, The" 2005 554166666666667 0 . 1.863 7198699999999999 "Bahamas, The" 2006 55 0 . 1.869 71988 "Bahamas, The" 2007 55 0 . 1.877 71998 "Bahamas, The" 2008 55 0 . 1.881 7202200000000001 "Bahamas, The" 2009 55 0 . 1.877 7206699999999999 "Bahamas, The" 2010 55 0 . 1.865 7214400000000001 "Bahamas, The" 2011 50625 0 . 1.847 7226300000000001 "Bahamas, The" 2012 475 0 . 1.828 7242400000000001 "Bahamas, The" 2013 475 0 . 1.81 7262 "Bahamas, The" 2014 475 0 . 1.794 7284699999999999 "Bahamas, The" 2015 475 0 . 1.782 7308799999999999 "Bahamas, The" 2016 475 0 . 1.771 7332899999999999 "Bahamas, The" 2017 425 0 . 1.762 73554 "Bahamas, The" 2018 425 0 . 1.752 73752 "Bahamas, The" 2019 425 0 . 1.743 7391800000000001 "Bahamas, The" 2020 425 0 . . . "Bahrain" 2001 106924779706275 0 23 2.731 7463500000000001 "Bahrain" 2002 840653404539386 0 35.17 2.663 74822 "Bahrain" 2003 8295205607476641 0 52.5 2.59 74999 "Bahrain" 2004 790431909212283 0 38.75 2.514 75167 "Bahrain" 2005 782185358255452 0 28 2.436 7532599999999999 "Bahrain" 2006 797523943035158 0 38 2.363 7547799999999999 "Bahrain" 2007 8266342679127719 0 21.17 2.297 75625 "Bahrain" 2008 82234606141522 0 36.5 2.241 7577 "Bahrain" 2009 794142857142857 0 . 2.197 75913 "Bahrain" 2010 72475 0 . 2.164 76057 "Bahrain" 2011 679083333333333 0 . 2.139 762 "Bahrain" 2012 6035 0 62.75 2.118 76342 "Bahrain" 2013 5935 0 58.26 2.098 7648399999999999 "Bahrain" 2014 586833333333333 0 58.69 2.078 76624 "Bahrain" 2015 516083333333333 0 54.86 2.056 76762 "Bahrain" 2016 . 0 . 2.033 76899 "Bahrain" 2017 . 0 58.88 2.01 77032 "Bahrain" 2018 . 0 60.85 1.987 77163 "Bahrain" 2019 . 0 61.31 1.964 77292 "Bahrain" 2020 . 0 . . . end
Thank you for your attention.
Comment