Exponential number in table for p value

[Jana Schue]

Dear Forum,

once again I have a new Stata question. I am in the process of creating the regression tables. For my logit regression I also want to show Wald Chi2 and Prob > Chi2 in the table. Apparently my Prob > Chi2 value is too small that it is output in exponential notation:

(Part of) my code:

xtlogit purpose dirty_l2 cf_l2 growth_l2 capexi_l2 adexi_l2 sl_l2 fs_l2 om_l2 i.fyear, re vce(robust)
outreg2 using main2.xls, append addstat(Log-Likelihood:, e(ll), Wald chi-squared:, e(chi2), Prob > Chi2, e(p)) stats(coef se) paren(se) dec(3) addtext(Year FE, Yes) sortvar(purpose dirty_l2 cf_l2 growth_l2 capexi_l2 adexi_l2 sl_l2 fs_l2 om_l2) drop(i.fyear)

The table:

 

Model
8
9

Value
Coefficient
AME
Coefficient
AME



Dependent Variable
Purpose
Purpose
Purpose
Purpose


Independent Variable

Dirtyt-2
Dirtyt-2


Dirtyt-2


-1.008**
-0.031**





(0.419)
(0.013)


Free Cash Flowt-2
0.003
0.000
-0.001
-0.000



(0.040)
(0.001)
(0.040)
(0.001)


Growtht-2
0.794
0.025
0.721
0.022



(0.762)
(0.024)
(0.776)
(0.024)


Capital Intensityt-2
-2.131
-0.066
-0.823
-0.026



(4.277)
(0.133)
(4.274)
(0.133)


Advertising Int.t-2
18.320***
0.572***
17.988***
0.559***



(3.540)
(0.120)
(3.644)
(0.122)


Slackt-2
-0.160
-0.005
-0.139
-0.004



(0.181)
(0.006)
(0.173)
(0.005)


Firm Sizet-2
0.602**
0.019**
0.667***
0.021***



(0.235)
(0.008)
(0.238)
(0.008)


Operating Margint-2
1.028
0.032
0.910
0.028



(1.474)
(0.046)
(1.461)
(0.045)


Observations
4,701
4,701
4,701
4,701


Number of gvkey
569

569



Year FE
Yes
Yes
Yes
Yes


Log-Likelihood
-730.3

-727.2



Wald chi2
82.91

83.17



Prob > Chi2
5.83e-10

1.13e-09

I have already tried to make this value larger by multiplying it, but unfortunately this does not work. Do you have a tip for me how to output this value as a normal 0.000 in the table?

Thank you very much!

King regards,
Jana

[Andrew Musau]

outreg2 is from SSC, as you are asked to explain (FAQ Advice #12). See how it is done here as an added text: https://www.statalist.org/forums/for...d-hausman-test

[Jana Schue]

Thank you for the link, Andrew! I'm still stuck with it, since I already built the value into the outreg2 command (with prob > chi2, e(p) in the addstat command). My problem is more that the p value is displayed as an exponential in the table (see the last row). I would prefer to list this number as a normal decimal number, i.e. as 0.000. Do you have a tip for me?

[Andrew Musau]

As usual, a reproducible example will increase your chances of getting useful replies.