Outputting logistic regression results using outreg2 command?

[Monzur Alam]

Dear all,

I am trying to output the raw coefficients and odds ratio of a logit model using outreg2. I am using the logit command to display the raw coefficients and the logistic command to display the odds ratios. However when I try to display the odds ratio using outreg2, I end up getting the raw coefficients instead of odds ratios, as shown in the last table at the bottom. I would like some advice on where I might be going wrong with the commands.

.
.
. logit `depvar' `indchars' `hhchars' //displays raw coefficients

Iteration 0:   log likelihood = -1632.8432  
Iteration 1:   log likelihood = -1490.0719  
Iteration 2:   log likelihood = -1454.3873  
Iteration 3:   log likelihood = -1451.2947  
Iteration 4:   log likelihood = -1450.5274  
Iteration 5:   log likelihood = -1450.5249  
Iteration 6:   log likelihood = -1450.5249  

Logistic regression                               Number of obs   =       5995
                                                  LR chi2(11)     =     364.64
                                                  Prob > chi2     =     0.0000
Log likelihood = -1450.5249                       Pseudo R2       =     0.1117

-------------------------------------------------------------------------------
     intl_mig |      Coef.   Std. Err.      z    P>|z|     [95% Conf. Interval]
--------------+----------------------------------------------------------------
          age |  -.0022388   .0033122    -0.68   0.499    -.0087306    .0042531
       hhsize |  -.1112763    .028104    -3.96   0.000    -.1663591   -.0561935
 own_land_hec |   .0007009   .0003733     1.88   0.060    -.0000307    .0014325
num_cows_ow~d |   .0001793   .0064792     0.03   0.978    -.0125197    .0128783
business_ow~d |   .6112691   .1071957     5.70   0.000     .4011693    .8213688
   community1 |   1.199658   .1617499     7.42   0.000     .8826338    1.516682
   community2 |  -.9685354   .2439517    -3.97   0.000    -1.446672   -.4903989
   community4 |  -2.067413   .3778745    -5.47   0.000    -2.808033   -1.326792
   community5 |   .3581054   .1765239     2.03   0.042      .012125    .7040858
   community6 |   -1.48619    .309946    -4.79   0.000    -2.093673   -.8787068
   community7 |   .7773251   .1681052     4.62   0.000     .4478449    1.106805
        _cons |  -2.358908   .2314787   -10.19   0.000    -2.812598   -1.905218
-------------------------------------------------------------------------------

. est store r1

.
. logistic `depvar' `indchars' `hhchars' //displays odds ratios

Logistic regression                               Number of obs   =       5995
                                                  LR chi2(11)     =     364.64
                                                  Prob > chi2     =     0.0000
Log likelihood = -1450.5249                       Pseudo R2       =     0.1117

-------------------------------------------------------------------------------
     intl_mig | Odds Ratio   Std. Err.      z    P>|z|     [95% Conf. Interval]
--------------+----------------------------------------------------------------
          age |   .9977638   .0033048    -0.68   0.499     .9913074    1.004262
       hhsize |   .8946915   .0251444    -3.96   0.000     .8467421    .9453562
 own_land_hec |   1.000701   .0003735     1.88   0.060     .9999693    1.001434
num_cows_ow~d |   1.000179   .0064804     0.03   0.978     .9875584    1.012962
business_ow~d |   1.842769   .1975369     5.70   0.000      1.49357     2.27361
   community1 |   3.318981   .5368448     7.42   0.000     2.417258    4.557078
   community2 |   .3796386   .0926135    -3.97   0.000     .2353523    .6123821
   community4 |   .1265127   .0478059    -5.47   0.000     .0603235     .265327
   community5 |   1.430616   .2525379     2.03   0.042     1.012199    2.021997
   community6 |    .226233     .07012    -4.79   0.000     .1232337    .4153197
   community7 |   2.175645   .3657372     4.62   0.000     1.564936     3.02468
        _cons |   .0945234   .0218802   -10.19   0.000     .0600488    .1487902
-------------------------------------------------------------------------------

. est store r2

. outreg2 [r1 r2] using "Results/migration.doc" , se aster /*
>  */  label word

 

(1)
(2)


r1
r2

VARIABLES
intl_mig
intl_mig





Age
-0.00224
-0.00224


(0.00331)
(0.00331)

hhsize
-0.111***
-0.111***


(0.0281)
(0.0281)

own_land_hec
0.000701*
0.000701*


(0.000373)
(0.000373)

num_cows_owned
0.000179
0.000179


(0.00648)
(0.00648)

business_owned
0.611***
0.611***


(0.107)
(0.107)

commun1
1.200***
1.200***


(0.162)
(0.162)

commun2
-0.969***
-0.969***


(0.244)
(0.244)

commun4
-2.067***
-2.067***


(0.378)
(0.378)

commun5
0.358**
0.358**


(0.177)
(0.177)

commun6
-1.486***
-1.486***


(0.310)
(0.310)

commun7
0.777***
0.777***


(0.168)
(0.168)

Constant
-2.359***
-2.359***


(0.231)
(0.231)





Observations
5,995
5,995

[Richard Williams]

See

help outreg2##s_10

[Oded Mcdossi]

You should add the - eform- option. As Richard note, please see the help outreg2

[Sartaj Alam]

Hi Manzoor,
With the given paradigm as you mentioned, you will not be able to get your desired results.
You may not need to run the model twice but you have to export results in two separate steps:

logistic `depvar' `indchars' `hhchars' //displays raw coefficients
est store OR
est store Coeff
outreg2 [Coeff] using "migration.doc" , stats(coef ci) alpha(0.001, 0.01, 0.05) replace
outreg2 [OR] using "migration.doc" , stats(coef ci) eform alpha(0.001, 0.01, 0.05)
Intrinsically logit and logistic commands are identical except the output display of results. So a single model is sufficient for getting both type of the results I hope this will suffice.

[Paul Martinez]

help outreg2 did not help me. See http://repec.org/bocode/o/outreg2.html. It provides actual examples.

Try this:

raw:
outreg2 using "Results/migration.doc"

odds ratio:
outreg2 using "Results/migration.doc" , eform cti(odds ratio)