Hello everyone. I am using esttab to make a table (in .tex) in which I have several columns in a row with the same dependent variable. I would like to have the dependent variable span multiple columns. I know I can use the "mgroups" command to do this, but the only way I can figure out how to tell stata the names of the dependent variables is to enter them manually ("price" and "weight" in the code below).
sysuse auto, clear
local i=1
foreach var of varlist weight price{
quietly reg `var' mpg
estimates store m`i', title("`:variable label `var''")
quietly reg `var' mpg foreign
estimates store m`i', title("`:variable label `var''")
local i=`i'+1
}
esttab m1 m2 m3 m4 using "C:\Users\rmheath\Documents\example.tex", tex label replace ///
nomtitle collabels(none) mgroups("weight" "price", pattern(1 0 1 0) prefix(\multicolumn{@span}{c}{) suffix(}) span erepeat(\cmidrule(lr){@span}))
I would love to find a way to tell mgroups to reference the title of the estimation, so that I don't have to go back manually and change the headings listed in mgroups if I change the dependent variables in a regression. Can anyone figure out how to do this?
thank you in advance if anyone can help!
Rachel
Related Posts with dependent variable spanning many columns in esttab
importing and appending loopsDear all, I tried appending some files using the following codes. Both worked but there are some pr…
looping and exporting multiple regression results into a single tableHello, I am attempting to export the results from multiple univariate regression models estimated us…
Identical static and dynamic forecasts using the forecast command with panel dataDear Statalist, I would like to ask a question about the forecast command when using panel data. I …
getting scatter and lfit to assign the same color for an observationHi All, I am using twoway to generate a scatterplot with an lfit overlay for several individual uni…
Endogenous regressor with Xtabond2Dear Stata forum: I am trying to estimate a dynamic panel in which, beyond the lagged dependent var…
Subscribe to:
Post Comments (Atom)
0 Response to dependent variable spanning many columns in esttab
Post a Comment