I have a correlation matrix I estimate in Stata:
estpost corr var1 var2 var3 var4, matrix listwise
I want to get the output to LaTeX, simultaneously displaying only 3 decimal places and significance stars. I can do the two things separately, but somehow can't get both.
esttab using TABLE2B.tex, replace cells("rho(fmt(%9.3f))") nonum not unstack compress label //version with correct formatting
esttab using TABLE2Bstars.tex, replace nonum not unstack compress label //version with stars.
I tried changing the formatting of the variables. It did not change the outcomes.
Try this:
. sysuse auto, clear
(1978 automobile data)
. estpost corr price mpg weight foreign, matrix listwise
| e(b) e(rho) e(p) e(count)
-------------+--------------------------------------------
price |
price | 1 1 74
mpg | -.4685967 -.4685967 .0000255 74
weight | .5386115 .5386115 7.42e-07 74
foreign | .0487195 .0487195 .6801851 74
mpg |
mpg | 1 1 74
weight | -.8071749 -.8071749 3.80e-18 74
foreign | .3933974 .3933974 .0005254 74
weight |
weight | 1 1 74
foreign | -.5928299 -.5928299 2.62e-08 74
foreign |
foreign | 1 1 74
. esttab using TABLE2B.tex, replace cells("rho(fmt(%9.3f))") nonum not unstack compress label
(output written to TABLE2B.tex)
. type TABLE2B.tex
{
\def\sym#1{\ifmmode^{#1}\else\(^{#1}\)\fi}
\begin{tabular}{l*{4}{c}}
\hline\hline
&\multicolumn{4}{c}{} \\
& Price&Mileage (mpg)&Weight (lbs.)&Car origin\\
& rho& rho& rho& rho\\
\hline
Price & 1.000& & & \\
Mileage (mpg) & -0.469& 1.000& & \\
Weight (lbs.) & 0.539& -0.807& 1.000& \\
Car origin & 0.049& 0.393& -0.593& 1.000\\
\hline
Observations & 74& & & \\
\hline\hline
\end{tabular}
}
. esttab using TABLE2Bstars.tex, replace cells(rho(fmt(%9.3f) star)) nonum not unstack compress label
(output written to TABLE2Bstars.tex)
. type TABLE2Bstars.tex
{
\def\sym#1{\ifmmode^{#1}\else\(^{#1}\)\fi}
\begin{tabular}{l*{4}{c}}
\hline\hline
&\multicolumn{4}{c}{} \\
& Price &Mileage (mpg) &Weight (lbs.) &Car origin \\
& rho & rho & rho & rho \\
\hline
Price & 1.000 & & & \\
Mileage (mpg) & -0.469\sym{***}& 1.000 & & \\
Weight (lbs.) & 0.539\sym{***}& -0.807\sym{***}& 1.000 & \\
Car origin & 0.049 & 0.393\sym{***}& -0.593\sym{***}& 1.000 \\
\hline
Observations & 74 & & & \\
\hline\hline
\end{tabular}
}
esttab is a wrapper for estout. Adding the noisily option to esttab lets you see what estout is doing under the hood. This can often help you find a solution to such problems.