I am trying to run multiple regressions across different specifications and I need to export the results where the dependent variables are rows instead of columns and independent variables in subgroups are columns. I am using Stata's collect commands to create this customized table.
For example:
gives me the following result:
I want to add a horizontal line between the price model and trunk space model but adding the following code adds a new empty row that I don't need.
Is there a cleaner way to get a horizontal line and some additional text as a row header?
For example:
Code:
sysuse auto.dta collect drop _all collect create price quietly: collect: reg price mpg rep78 quietly: collect: reg price mpg rep78 collect create trunk quietly: collect: reg trunk mpg rep78 if foreign==1 quietly: collect: reg trunk mpg rep78 if foreign==1 collect combine new= price trunk collect layout (coleq#result[_r_b _r_se]) (cmdset#colname[mpg rep78] extra) collect stars _r_p 0.01 "***" 0.05 "** " 0.1 "* ", attach(_r_b) shownote collect style row stack, spacer delimiter(" x ") collect label levels cmdset 1 "Pooled" 2 "Foreign", modify collect style cell cell_type[item column-header], halign(center) collect style cell, nformat(%5.3f) collect style cell border_block, border(right, pattern(nil)) collect style cell result[_r_se], sformat("(%s)") collect style header result, level(hide) collect style column, dups(center) collect preview
Code:
--------------------------------------------------------------------------------------- Pooled Foreign Mileage (mpg) Repair record 1978 Mileage (mpg) Repair record 1978 --------------------------------------------------------------------------------------- Price -271.643*** 666.957* -271.643*** 666.957* (57.771) (342.356) (57.771) (342.356) Trunk space (cu. ft.) -0.098 0.368 -0.098 0.368 (0.121) (1.061) (0.121) (1.061) --------------------------------------------------------------------------------------- *** p<.01, ** p<.05, * p<.1
Code:
collect style cell coleq[trunk], border(top, pattern(single)) --------------------------------------------------------------------------------------- Pooled Foreign Mileage (mpg) Repair record 1978 Mileage (mpg) Repair record 1978 --------------------------------------------------------------------------------------- Price -271.643*** 666.957* -271.643*** 666.957* (57.771) (342.356) (57.771) (342.356) --------------------------------------------------------------------------------------- --------------------------------------------------------------------------------------- Trunk space (cu. ft.) -0.098 0.368 -0.098 0.368 --------------------------------------------------------------------------------------- (0.121) (1.061) (0.121) (1.061) --------------------------------------------------------------------------------------- *** p<.01, ** p<.05, * p<.1