I conducted logit regressions using eststo for three different countries and then put the results together in a nice format using eststab. The problem is that when I get odds ratios lower than 1, which are denoted using dot instead of zero dot (for example .7 instead of 0.7). eststab is not only changing this to minus sign but also it displays different odds ratio.
In the example below, you can see it if you run the following commands:
Code:
eststo: quietly logit achieved_all i.rural i.not_poor i.Bicycle i.Motor_cycle i.car_all_type inc_cap_oecd_doll indirect clean_fuels tot_resid_fuels share_dirty_fuels F2 F8 F7 F9 F11 if country_id==1, or esttab,pr2 scalars (chi2) drop( 0.rural 0.not_poor 0.Bicycle 0.Motor_cycle 0.car_all_type ) wide compress
Thank you for your help,
Cheers,
Marta
Code:
* Example generated by -dataex-. To install: ssc install dataex clear input float(country_id achieved_all rural not_poor Bicycle Motor_cycle car_all_type inc_cap_oecd_doll indirect clean_fuels tot_resid_fuels share_dirty_fuels F2 F8 F7 F9 F11) 1 0 1 0 0 0 0 757.9745 1.818205 1.3209975 1.3209975 0 0 .7429588 1.0246736 1.1186874 1.0292457 1 0 1 1 1 0 0 2673.8345 1.4272217 1.8167483 1.8167483 0 0 .7429588 .2917905 .9167902 .1812828 1 1 0 1 1 0 0 991.9992 5.540638 2.540866 2.540866 0 0 .7429588 1.0246736 1.1186874 .1787506 1 1 0 1 1 1 0 0 5.508 2.800494 2.800494 0 .9923012 .7429588 1.0427761 1.1186874 1.0267136 1 1 0 1 0 0 0 1706.7218 3.9105165 6.034572 6.034572 0 0 .5373792 1.0246736 1.1186874 1.0267136 1 1 0 0 0 1 0 3462.32 4.135731 3.46402 3.46402 0 .4961506 .7429588 1.0427761 1.1186874 .1787506 1 1 0 1 0 1 0 2483.2886 10.465042 3.6580694 3.6580694 0 .4961506 .7429588 .9914134 1.1186874 .1787506 1 1 0 1 0 0 0 1280.9094 2.086266 1.8023653 1.8023653 0 0 .5373792 1.0246736 1.1186874 .1812828 1 1 0 1 1 1 0 4134.4067 8.81647 3.972038 3.972038 0 .9923012 .7429588 1.0427761 1.1186874 .1787506 1 1 0 1 0 0 0 1358.3536 3.374758 1.0038222 1.0038222 0 0 .7429588 .9914134 1.1186874 .1787506 1 1 0 0 0 1 0 1490.486 6.854953 4.976077 4.976077 0 .4961506 .7429588 1.0246736 1.1186874 1.0267136 1 0 0 1 0 0 0 1089.1621 4.0606194 7.891852 7.891852 0 0 .7429588 1.0427761 1.1186874 .1787506 1 0 1 0 1 0 0 574.3931 1.6343614 .3921904 .3921904 0 0 .5373792 0 .10576556 0 1 0 1 1 1 0 0 139.79893 .7215557 2.3682427 2.3682427 0 0 .20557962 1.0246736 .5258843 .1787506 1 0 1 0 1 0 0 276.6452 .7938556 .10501961 .10501961 0 0 .5373792 .018102502 .3873815 .1812828 1 0 0 1 1 1 0 8215.799 3.288267 2.196237 2.196237 0 .4961506 .7429588 1.0246736 1.1186874 .1787506 1 0 0 1 0 0 0 23319.09 18.159407 2.623492 2.623492 0 0 .9305042 1.0246736 1.1186874 1.0267136 1 1 0 1 0 1 0 3734.9194 8.443437 4.6054773 4.6054773 0 .4961506 .7429588 1.0427761 1.1186874 .1787506 1 0 0 1 0 1 0 6255.727 8.710135 3.639527 3.639527 0 0 .7429588 1.0246736 .9167902 1.0267136 1 0 0 1 0 0 0 1375.408 2.4173565 1.29989 1.29989 0 0 .7429588 1.0246736 1.1186874 .1812828 1 0 1 1 1 1 0 6045.034 6.661806 1.5452955 1.5452955 0 .4961506 1.1360838 1.0246736 .9167902 .1812828 1 0 1 0 0 0 0 546.68915 .623929 .03063987 .03063987 0 0 0 0 .5258843 .1787506 1 0 0 1 1 0 0 2222.9133 1.0951575 .3325109 .3325109 0 0 .7429588 1.0246736 1.1186874 .1787506 1 0 0 0 0 0 0 750.361 8.661407 2.1615949 2.1615949 0 0 .7429588 1.0246736 1.1186874 1.0267136 1 0 0 0 0 1 0 501.7462 2.0649343 2.773471 2.773471 0 .4961506 .7429588 1.0246736 1.1186874 .1787506 1 0 1 0 1 0 0 289.3862 .4500268 .13277277 .13277277 0 0 .5373792 0 .7277814 -.002532199 1 1 0 1 1 1 1 7724.405 5.886311 2.737499 2.737499 0 .9923012 .7429588 .9914134 1.1186874 1.0267136 1 1 0 1 1 0 0 521.1075 8.950868 4.2190456 4.2190456 0 0 .7429588 1.0246736 1.1186874 .1812828 1 0 0 0 0 0 0 380.3408 2.1151793 1.886821 1.886821 0 0 .7429588 1.0246736 .9167902 1.0267136 1 0 1 0 1 0 0 272.80994 12.74034 3.6933355 3.6933355 0 0 .7429588 .24042773 .5258843 .1787506 1 0 1 1 1 1 0 738.4012 .8541672 .13288856 .13288856 0 0 .7429588 .06946525 .4151386 .1787506 1 1 0 1 0 0 0 2456.785 2.4539504 3.6827474 3.6827474 0 0 .7429588 1.0246736 1.1186874 1.0267136 1 1 1 1 1 0 0 378.91965 1.8898576 1.7207745 1.7207745 0 .4961506 .7429588 1.0427761 1.1186874 .1787506 1 0 0 1 0 1 0 2846.7114 2.0611656 4.4000807 4.4000807 0 .4961506 1.1360838 1.0427761 1.1186874 1.0267136 1 0 1 1 0 1 0 2250.412 5.783936 1.6091415 1.6091415 0 0 .7429588 1.0427761 .9167902 .1812828 1 1 0 1 0 0 0 1278.676 2.058258 2.0978172 2.0978172 0 .4961506 .7429588 1.0246736 1.1186874 1.0267136 1 1 0 1 0 1 0 51.34093 1.5561166 3.349987 3.349987 0 .9923012 .7429588 1.0427761 1.1186874 .1812828 1 0 1 1 0 0 0 476.5765 2.985764 1.2590555 1.2590555 0 0 .5373792 1.0427761 1.1186874 0 1 0 0 1 0 0 0 1908.5078 10.664527 4.489582 4.489582 0 .4961506 .7429588 1.0246736 1.1186874 1.0267136 1 0 1 1 1 0 0 815.5109 .8282692 .140068 .140068 0 0 .5373792 0 .27663592 .1787506 1 0 1 0 0 0 0 41.9593 .49353355 .26947635 .26947635 0 0 0 .05136275 .2442683 .1787506 1 0 1 1 0 0 0 479.6558 3.404394 2.752832 2.752832 0 0 .7429588 1.0246736 1.1186874 1.0267136 1 0 0 1 0 0 0 886.7067 3.116522 2.4641626 2.4641626 0 0 1.1360838 1.0246736 1.1186874 1.0267136 1 0 1 1 0 0 0 428.92395 2.911554 .1823392 .1823392 0 0 .5373792 .05136275 .3873815 .1787506 1 1 0 1 1 0 0 1235.829 2.055065 .628662 .628662 0 0 .7429588 .9914134 1.1186874 1.0292457 1 1 0 1 1 1 0 2643.436 2.485381 1.9447215 1.9447215 0 0 .7429588 1.0246736 1.1186874 .1812828 1 0 0 1 0 0 0 967.5109 1.8017677 2.411617 2.411617 0 0 .5373792 .9733109 1.1186874 1.0267136 1 0 1 1 1 0 0 784.4089 1.990735 .05106645 .05106645 0 0 .7429588 .018102502 .4151386 .1787506 1 0 0 0 0 0 0 613.3909 2.0426724 2.2747047 2.2747047 0 0 .7429588 1.0246736 1.1186874 1.0267136 1 0 0 0 0 0 0 2751.211 2.99116 3.8082156 3.8082156 0 .4961506 .7429588 1.0246736 1.1186874 1.0267136 1 0 0 1 0 0 0 14484.42 2.1035259 1.9708703 1.9708703 0 0 .7429588 .9914134 .9167902 1.0267136 1 0 0 1 0 1 0 1591.8506 3.1408675 3.718132 3.718132 0 .4961506 .7429588 1.0246736 1.1186874 .1787506 1 1 0 1 0 0 0 2803.3215 5.308203 1.9413234 1.9413234 0 0 .5373792 1.0246736 1.1186874 1.0267136 1 0 0 1 0 1 0 2860.043 4.305994 2.0286179 2.0286179 0 0 .7429588 .24042773 1.1186874 .1787506 1 0 0 1 0 1 0 893.7509 4.813969 1.370874 1.370874 0 .4961506 .7429588 1.0427761 1.1186874 1.0267136 1 0 0 1 0 0 0 1474.343 2.0205126 1.6385516 1.6385516 0 0 .7429588 .9733109 1.1186874 1.0267136 1 1 0 1 0 0 0 2623.758 3.017717 3.140761 3.140761 0 0 .7429588 1.0427761 1.1186874 1.0292457 1 0 1 0 0 0 0 685.8723 4.924563 3.944714 3.944714 0 0 .7429588 .9914134 .5258843 .1812828 1 0 0 0 0 1 1 1841.878 43.23208 4.3874226 4.3874226 0 .4961506 .7429588 1.0246736 1.1186874 .1787506 1 0 0 0 0 0 0 1524.4933 8.48151 6.750727 6.750727 0 0 .7429588 1.0246736 1.1186874 1.0267136 1 1 0 0 1 0 0 1881.155 2.0411909 2.2448184 2.2448184 0 0 .7429588 1.0246736 1.1186874 1.0267136 1 0 1 1 1 0 0 14438.918 6.117969 2.534173 2.534173 0 0 .7429588 1.0427761 .9167902 .1812828 1 0 0 1 0 0 0 1600.8265 15.319732 1.9584242 1.9584242 0 0 .5373792 1.0427761 1.1186874 1.0267136 1 0 0 1 1 0 0 1370.4452 4.357891 3.068029 3.068029 0 0 .7429588 .9733109 1.1186874 .1787506 1 0 0 0 0 1 0 901.9169 4.3425703 .925101 .925101 0 0 .7429588 1.0246736 1.1186874 .1787506 1 0 1 0 1 0 0 772.8143 .6059626 .4289582 .4289582 0 0 0 0 .7277814 0 1 0 0 1 0 0 0 2476.276 3.9078 1.7750047 1.7750047 0 0 .7429588 1.0246736 1.1186874 1.0267136 1 0 0 0 0 0 0 656.4601 .9557348 2.0507808 2.0507808 0 0 .7429588 1.0246736 1.1186874 1.0267136 1 0 1 1 1 1 0 7146.722 7.156996 2.5807204 2.5807204 0 0 .7429588 .7509856 1.1186874 .1812828 1 0 0 0 0 0 0 8356.845 1.3894944 2.42955 2.42955 0 0 .7429588 1.0427761 .9167902 .1787506 1 1 0 1 0 0 0 2722.076 10.581377 6.614033 6.614033 0 .4961506 .7429588 .9914134 1.1186874 1.0267136 1 1 0 1 0 1 0 2003.3496 14.024404 2.992872 2.992872 0 .4961506 .5373792 1.0427761 1.1186874 .1812828 1 1 0 1 0 0 0 2455.269 2.03014 1.74597 1.74597 0 0 .7429588 1.0246736 .9167902 1.0267136 1 1 0 0 1 0 0 4003.053 6.668846 3.325474 3.325474 0 0 .7429588 1.0427761 1.1186874 1.0267136 1 1 0 1 0 0 0 2817.865 8.70369 2.3510478 2.3510478 0 0 .7429588 1.0246736 1.1186874 1.0267136 1 0 1 1 1 0 0 224.4214 .8666341 .09191962 .09191962 0 0 .5373792 .018102502 .5258843 -.002532199 1 0 0 1 0 0 0 1796.755 3.286916 2.2554588 2.2554588 0 .4961506 .7429588 .9733109 1.1186874 1.0267136 1 0 0 1 0 0 0 246.34174 .8734494 .694689 .694689 0 0 0 .9733109 1.1186874 1.0292457 1 1 0 1 0 0 0 1664.386 4.675694 2.916072 2.916072 0 0 .9305042 1.0246736 1.1186874 1.0267136 1 0 1 1 1 0 0 140.60735 1.1907806 .12255949 .12255949 0 0 0 .06946525 .5258843 -.002532199 1 0 0 1 0 1 0 3151.4595 1.5809453 3.140761 3.140761 0 .9923012 .7429588 1.0246736 1.1186874 .1787506 1 0 1 1 1 1 0 1057.8483 3.7813365 .6355289 .6355289 0 0 .7429588 .9733109 .9167902 1.0267136 1 1 0 1 0 0 0 1705.443 4.1641617 2.448053 2.448053 0 0 .7429588 .9733109 1.1186874 .1787506 1 0 0 1 1 0 0 1724.392 2.340013 3.7173524 3.7173524 0 0 .7429588 1.0427761 1.1186874 .1787506 1 1 0 1 1 1 1 9518.36 9.579969 6.614033 6.614033 0 .9923012 .7429588 1.0427761 1.1186874 1.0267136 1 0 0 1 0 0 0 966.0508 1.3245606 1.393438 1.393438 0 0 .7429588 .9914134 1.1186874 1.0267136 1 0 0 1 1 0 0 1270.177 1.747799 .8372993 .8372993 0 0 .7429588 .2917905 1.1186874 .1812828 1 1 1 1 0 0 0 1168.8821 3.062119 .1983231 .1983231 0 0 .7429588 .9914134 .5258843 .1787506 1 0 0 1 0 0 0 506.2879 2.591333 2.3306327 2.3306327 0 0 .7429588 1.0427761 1.1186874 1.0267136 1 0 0 1 0 0 0 963.946 1.0315026 2.641995 2.641995 0 0 .7429588 .9733109 1.1186874 1.0267136 1 0 0 0 0 1 1 5606.643 5.723766 1.9952846 1.9952846 0 .4961506 1.1360838 1.0246736 1.1186874 .1787506 1 0 0 0 0 0 0 1592.931 3.78114 2.540333 2.540333 0 .4961506 .7429588 .9733109 .9167902 .1812828 1 0 0 1 0 1 0 3753.912 1.7877698 2.43646 2.43646 0 .4961506 1.1360838 1.0427761 1.1186874 1.0267136 1 0 1 1 0 0 0 781.6613 1.6665493 2.318872 2.318872 0 0 .5373792 1.0246736 1.1186874 .1812828 1 0 0 1 0 0 0 2011.0865 4.7554226 9.690102 9.690102 0 .4961506 .7429588 1.0427761 1.1186874 .1787506 1 1 0 1 1 0 0 9456.769 17.186018 2.257081 2.257081 0 0 1.1360838 1.0427761 1.1186874 1.0267136 1 0 0 1 1 0 0 2077.8503 2.0123734 1.546868 1.546868 0 0 .7429588 .9914134 1.1186874 1.0267136 1 0 0 1 0 1 0 1703.4293 3.8445356 1.733584 1.733584 0 0 .7429588 .9733109 1.1186874 1.0292457 1 0 0 1 0 0 0 6551.735 5.382673 2.641995 2.641995 0 0 .7429588 1.0246736 1.1186874 .1812828 1 0 0 0 1 0 0 2225.0776 2.2129316 2.729646 2.729646 0 .4961506 .7429588 1.0427761 1.1186874 .1787506 end label values country_id country label def country 1 "Nepal", modify label values achieved_all achieved_all label def achieved_all 0 "Not achieved", modify label def achieved_all 1 "Achieved", modify label values Bicycle V06_05 label values Motor_cycle V06_05 label values car_all_type V06_05 label def V06_05 1 "yes", modify
0 Response to Esttab produces wrong results
Post a Comment