Hi,
I'm using estout to export some regression results, and I noticed that all of the p-values are negative in the excel tables - Has this been happening for anyone else/does anyone know how to fix it?
The odd thing is that it seems to only be happening for p-values and not coefficients or 95% confidence intervals (at least I hope its not happening for coefficients...it's sort of hard to tell if something is truly negative in the table or if estout is just putting a negative there itself - Not sure if anyone is able to confirm it's only happening for p-values as well?)
Thanks,
David
I'm using estout to export some regression results, and I noticed that all of the p-values are negative in the excel tables - Has this been happening for anyone else/does anyone know how to fix it?
The odd thing is that it seems to only be happening for p-values and not coefficients or 95% confidence intervals (at least I hope its not happening for coefficients...it's sort of hard to tell if something is truly negative in the table or if estout is just putting a negative there itself - Not sure if anyone is able to confirm it's only happening for p-values as well?)
Thanks,
David
Code:
* Example generated by -dataex-. For more info, type help dataex
clear
input double w1c_bs_bmi float w1c_rage_calc byte w1cm061 double(w1_w2_Intersalt_change w1_w3_Intersalt_change hivfinalresult Dolutegravir) byte Male double w1_w2_bp_meds_change
24.38875492201093 54 1 . .12270747950734151 1 0 1 0
28.44095497516423 46 2 . -.4065123835823585 1 0 0 0
31.887125220458554 53 2 . . 1 0 0 0
26.168047337278104 62 2 . . 1 0 1 0
19.356383160630624 46 2 . . 1 0 1 0
23.2409972299169 45 1 . . 1 0 1 0
44.503873674325554 56 2 . . 1 0 0 0
22.617211806400995 63 1 -1.6131200422834748 . 1 0 1 0
33.51756773185946 43 2 . . 1 0 0 0
16.377001892039996 52 2 . . 1 0 0 0
25.987896048415806 52 2 . . 1 0 0 0
23.515624999999996 52 2 . . . 0 0 0
27.9478385629072 88 0 . . 1 0 1 0
26.564344746162927 65 2 -.32354643153599394 .7045210748574389 1 0 0 0
19.027032480220047 45 2 . . 1 0 1 0
18.719723183391007 76 2 . . 1 0 1 0
23.65207513489391 62 2 . . 1 0 0 0
22.749668298663106 44 0 . . 1 0 1 0
14.757355027906534 42 2 -.30875419968261086 . 1 0 0 0
27.71059044733071 48 2 . . 1 0 0 0
23.49523687470631 44 2 . -.7469580396718878 1 0 0 0
21.25689595308823 46 2 . .2829360954408955 3 0 1 0
24.44204816521256 81 0 . . 1 0 1 0
28.237091911734172 63 2 .8045923588998809 .2091453588998804 1 0 1 0
28.106508875739646 42 2 1.0467960075878167 -.24895041634711967 1 0 0 0
31.87265541570449 48 2 .052643122569459244 . 1 0 0 0
20.331664527535292 57 2 . . 1 0 0 0
.e 44 2 . . 1 0 1 0
19.30881284975864 59 2 . . 1 0 0 0
20.81875605057079 52 2 .14234285107988498 .5105974617747706 1 0 0 0
22.192009122406912 52 2 . .9707489528050486 1 0 0 1
28.634363773263487 53 2 . . 2 0 0 0
21.245674740484432 48 1 . -1.5769189256693168 1 0 1 0
24.957955597130034 46 2 -.4904018028605326 .7381298902623312 1 0 0 0
30.75012232300802 49 2 .3477633651316223 .014142710064178665 1 0 0 0
22.326824618468763 65 2 . . 1 0 0 1
27.13482982502111 61 2 . . 1 0 0 0
46.25819234872732 65 2 . .5604643772434441 1 0 0 0
19.780124653739612 42 2 . . 2 0 0 0
26.472424557752337 56 2 . . 1 0 0 0
26.09534669532038 48 2 . 1.4472632446048672 2 0 0 0
21.07148300563938 91 2 . . 1 0 1 0
19.496405585456735 69 2 . -.8433179478115369 1 0 0 0
19.633083905688114 44 2 . -.29523220698255637 1 0 0 0
33.953329680214225 56 2 .1149296592548743 .473177659254874 1 0 0 0
24.864806617784122 62 1 -1.2512378618924465 -.23633612776158675 1 0 1 0
23.044528817987164 42 2 . -.12387422061002695 1 0 1 0
27.4780798007533 52 2 . -.20451145937069848 1 0 0 0
20.568785751957485 41 2 . . 1 0 0 0
20.060954438486167 52 2 -.41511771647509965 -.9484572283845849 3 0 0 0
30.274628369866466 43 2 . . 1 0 0 0
30.84627667295689 84 2 . . 1 0 1 0
31.423130193905816 74 2 . . 1 0 0 0
31.46827604421293 45 2 1.0974887893444016 1.0515809328838306 1 0 0 0
21.52433425160698 45 2 1.1962286667943416 1.5074979735570373 1 0 1 0
21.04308390022676 63 0 . . 1 0 1 0
15.168065915545707 55 1 . 1.1721683452613272 . 0 1 0
23.420176232673636 60 1 1.240443137479322 1.3668974294715102 1 0 1 0
19.753674064377936 56 2 . . 1 0 1 0
28.479886080455675 57 2 . . 1 0 0 0
27.300159529803192 44 2 -.8170018108711425 -.4155054269752685 1 0 0 0
21.085612039587495 57 0 . . 1 0 1 0
31.362632490702044 51 2 .2525211414612847 .8200098995102958 1 0 0 0
20.533501365259397 43 1 . . 1 0 1 0
35.116382925421256 76 2 . . 1 0 0 0
24.105694197635792 43 2 . . 1 0 0 0
30.67061544078867 82 2 . . 1 0 0 0
26.116206296386476 45 2 . -.9855489195256086 1 0 1 0
30.875838779000922 80 2 . . 1 0 0 0
19.441925173242698 44 0 . . 1 0 1 0
25.316200554295794 45 2 . -.10464442152655806 1 0 0 0
28.861053719008268 53 2 . .4493941390380858 1 0 0 0
22.617187499999996 47 2 -.2281850743026732 -.23809963200378403 1 0 0 0
22.145328719723185 58 2 . . 1 0 1 0
31.127785130710826 42 2 -.09112118117797996 -.5123764998730476 1 0 0 0
37.696293659269806 55 2 -.5493594328644966 .02906343783252563 1 0 0 0
21.346294365399295 47 1 . -.289618376041447 1 0 1 0
39.23459743065468 44 2 1.1093033561372119 .1667681168031061 1 0 0 0
27.268005540166204 62 2 . . 1 0 0 1
25.078369905956112 41 2 . . 1 0 0 0
20.926643833038504 64 2 .9273510485466869 1.8481198078240308 1 0 1 0
29.846175831130257 44 2 1.6215419124009696 . 1 0 0 0
26.25739644970414 60 1 . . . 0 1 0
22.7094069351035 56 0 . . 1 0 1 0
25.078369905956112 65 2 . . 1 0 1 0
.e 65 0 . . 1 0 0 1
26.218820861678008 49 2 -1.7987712172691017 -.7363268884116798 1 0 1 0
26.089795918367347 62 2 . . 1 0 1 0
26.013696431626308 51 2 .5993013395543643 .8038712063222477 2 0 0 0
24.582880017274455 52 2 . .6579784743350467 1 0 1 0
40.14896709779414 45 2 . . 1 0 0 0
19.100091827364558 44 2 . 2.485893135163334 1 0 1 0
23.417888756771042 63 0 . . 1 0 1 0
20.979881656804732 45 2 .060967946362783465 . 1 0 0 0
22.09671026555688 68 2 . . 1 0 1 0
23.220855583884926 46 2 . . . 0 1 0
26.640675763482786 41 2 .14990481054124327 2.7691206762639 1 0 1 0
33.39471302393808 55 2 . . 1 0 0 0
26.91272587466359 41 2 . . 1 0 0 0
24.881632653061224 54 2 . -.08826764263791453 . 0 1 0
end
label values w1cm061 SMOKING
label def SMOKING 0 "Not current smoker", modify
label def SMOKING 1 "Current smoker", modify
label def SMOKING 2 "Missing Smoking data", modify
label values hivfinalresult HIV2
label def HIV2 1 "HIV+", modify
label def HIV2 2 "HIV-", modify
label def HIV2 3 "HIV Indeterminate", modify
label values Male RSEX
label def RSEX 0 "Female", modify
label def RSEX 1 "Male", modify
label values w1_w2_bp_meds_change MEDS
label def MEDS 0 "No Med Change", modify
label def MEDS 1 "No Meds -> On Meds", modify
eststo clear
eststo, title("Model 7"): regress w1_w3_Intersalt_change w1c_rage_calc i.Male w1c_bs_bmi i.w1_w2_bp_meds_change i.w1cm061 ib2.hivfinalresult Dolutegravir
estout using "Negative P-Values.xls", cells((b(fmt(3) star label("Coef.")) & ci(fmt(3) par label("[95% C.I.]")) p(fmt(3) par label("P-Value")))) stats(N, labels("N = ")) incelldelimiter(" ") ///
varwidth(30) modelwidth(15) label replace
Comment