Following on from a previous post I would like to incorporate the output from using lincom into exported results using esttout. Using estadd gets me most of the way there, but I end up with two separate rows for the coefficient & standard error- similarly, I can add the p-value as an additional scalar using ttail, but what I really want is for it to format as one row with parenthesis & sig. stars similar to the other output. Is there a way to achieve this within estout?
Currently, output looks like:
I would like it to look like:
Currently, output looks like:
Code:
sysuse auto, clear
gen goodmpg = 0
replace goodmpg = 1 if mpg > 25
gen interact = goodmpg * foreign
reg price goodmpg foreign interact
est store reg1
lincom goodmpg + foreign
estadd scalar coeff = `r(estimate)'
estadd scalar serr = `r(se)'
. esttab reg1, stats(coeff serr) drop(_cons)
----------------------------
(1)
price
----------------------------
goodmpg -1786.8
(-1.54)
foreign 1056.5
(1.24)
interact -1308.2
(-0.75)
----------------------------
coeff -730.3
serr 1556.8
----------------------------
t statistics in parentheses
* p<0.05, ** p<0.01, *** p<0.001
Code:
----------------------------
(1)
price
----------------------------
goodmpg -1786.8
(-1.54)
foreign 1056.5
(1.24)
interact -1308.2
(-0.75)
----------------------------
label -730.3
(1556.8)
----------------------------
t statistics in parentheses
* p<0.05, ** p<0.01, *** p<0.001
