Exporting a table to LaTeX using tabstat

[Lorenzo Garbarino]

Good afternoon,

This is my first post here.

I have been trying, without success, to create a table and then export it to LaTeX with packages like outreg2 or estout. Nothing seems to work. I have looked through many blog posts but did not find what I was looking for. Also, there is no documentation because the packages are user-created (not tabstat of course).

I tried manually making the table, following a code from a previous post. I need to use regione because I have panel data that spans across 6 years and 20 regions in Italy.

levels regione, local(reg_list)
local vlist reg_list

* compute summary statistics
table (var reg_list) (result), ///
stat(mean `vlist') ///
stat(sd `vlist') ///
stat(min `vlist') ///
stat(max `vlist') ///
name(reg_list)

I also tried tabstat with: tabstat pred_ineq gov_eff, by(regione) stat(mean sd min max) nototal long col(stat), where pred_ineq is predicted inequality and gov_eff is a measure of government efficiency (these are two of my variables in reg_list).

So, the first problem is that I do not have an appropriate table, sorted by the 20 regions. Then, I should export it to LaTeX.

Can someone help?

Thank you very much,

LG

[Dan Palmer]

This isn't a direct answer to the specific question(s) you asked, but I'll simply note that - in case you don't know already - integrating Stata and LaTeX can be a rewarding but somewhat tedious undertaking. If you haven't already, I'd encourage you to get as much foundational knowledge as you can before attempting to make headway against specific tasks. I would carefully review, in particular, Gini & Pasquini's (2006) helpful primer.

[Jeff Pitblado (StataCorp)]

In the following I use Stata 17 with the new collect suite and
updated table command as a working example of how you can produce
a table that you can export to LaTeX.

webuse nhanes2l

* list of the variables for computing some summary statistics
local vlist height weight bpsystol bpdiast tcresult tgresult hdresult

/*
row specification is (region var):
 - region is a variable (in the dataset) that identifies samples
   (observation groups), the levels of -region- are attached to the
   computed statistics so we can identify which group of observations
   were used to compute a given statistic
 - var is a keyword that identifies a dimension created by -table- used
   to identify which variable was used to compute a given statistic, and
   is used here to place the variable labels in the row headers

column specification is (result):
 - result is another keyword that identifies the dimension used to
   identify the statistic computed for a given value (item in the
   collection), and is used here to place the result labels in the
   column headers
*/

table (region var) (result), ///
    stat(mean `vlist') ///
    stat(sd `vlist') ///
    stat(min `vlist') ///
    stat(max `vlist')

* shorten some result labels
collect label levels result sd "SD" min "Min" max "Max", modify

* use a fixed numeric format for mean and sd
collect style cell result[mean sd], nformat(%9.2f)

* review style changes
collect preview

* publish the table to a LaTeX file
collect export table.tex, replace

Here is the resulting LaTeX file.

\documentclass{article}
\usepackage{multirow}
\usepackage{amsmath}
\usepackage{ulem}
\usepackage[table]{xcolor}
\begin{document}
\begin{table}[!h]
\centering
\begin{tabular}{lllll}
\cline{1-5}
\multicolumn{1}{c}{} &
  \multicolumn{1}{|r}{Mean} &
  \multicolumn{1}{r}{SD} &
  \multicolumn{1}{r}{Min} &
  \multicolumn{1}{r}{Max} \\
\cline{1-5}
\multicolumn{1}{l}{Region} &
  \multicolumn{1}{|r}{} &
  \multicolumn{1}{r}{} &
  \multicolumn{1}{r}{} &
  \multicolumn{1}{r}{} \\
\multicolumn{1}{l}{\hspace{1em}NE} &
  \multicolumn{1}{|r}{} &
  \multicolumn{1}{r}{} &
  \multicolumn{1}{r}{} &
  \multicolumn{1}{r}{} \\
\multicolumn{1}{l}{\hspace{2em}Height (cm)} &
  \multicolumn{1}{|r}{167.20} &
  \multicolumn{1}{r}{9.73} &
  \multicolumn{1}{r}{138} &
  \multicolumn{1}{r}{200} \\
\multicolumn{1}{l}{\hspace{2em}Weight (kg)} &
  \multicolumn{1}{|r}{71.65} &
  \multicolumn{1}{r}{14.92} &
  \multicolumn{1}{r}{39.12} &
  \multicolumn{1}{r}{148.21} \\
\multicolumn{1}{l}{\hspace{2em}Systolic blood pressure} &
  \multicolumn{1}{|r}{131.38} &
  \multicolumn{1}{r}{24.31} &
  \multicolumn{1}{r}{80} &
  \multicolumn{1}{r}{300} \\
\multicolumn{1}{l}{\hspace{2em}Diastolic blood pressure} &
  \multicolumn{1}{|r}{81.84} &
  \multicolumn{1}{r}{13.31} &
  \multicolumn{1}{r}{35} &
  \multicolumn{1}{r}{150} \\
\multicolumn{1}{l}{\hspace{2em}Serum cholesterol (mg/dL)} &
  \multicolumn{1}{|r}{220.86} &
  \multicolumn{1}{r}{48.61} &
  \multicolumn{1}{r}{94} &
  \multicolumn{1}{r}{426} \\
\multicolumn{1}{l}{\hspace{2em}Serum triglycerides (mg/dL)} &
  \multicolumn{1}{|r}{145.08} &
  \multicolumn{1}{r}{89.56} &
  \multicolumn{1}{r}{35} &
  \multicolumn{1}{r}{1246} \\
\multicolumn{1}{l}{\hspace{2em}High density lipids (mg/dL)} &
  \multicolumn{1}{|r}{49.71} &
  \multicolumn{1}{r}{14.33} &
  \multicolumn{1}{r}{17} &
  \multicolumn{1}{r}{122} \\
\multicolumn{1}{l}{\hspace{1em}MW} &
  \multicolumn{1}{|r}{} &
  \multicolumn{1}{r}{} &
  \multicolumn{1}{r}{} &
  \multicolumn{1}{r}{} \\
\multicolumn{1}{l}{\hspace{2em}Height (cm)} &
  \multicolumn{1}{|r}{167.89} &
  \multicolumn{1}{r}{9.50} &
  \multicolumn{1}{r}{142.398} &
  \multicolumn{1}{r}{198.297} \\
\multicolumn{1}{l}{\hspace{2em}Weight (kg)} &
  \multicolumn{1}{|r}{72.05} &
  \multicolumn{1}{r}{15.34} &
  \multicolumn{1}{r}{34.93} &
  \multicolumn{1}{r}{159.44} \\
\multicolumn{1}{l}{\hspace{2em}Systolic blood pressure} &
  \multicolumn{1}{|r}{130.49} &
  \multicolumn{1}{r}{22.50} &
  \multicolumn{1}{r}{65} &
  \multicolumn{1}{r}{254} \\
\multicolumn{1}{l}{\hspace{2em}Diastolic blood pressure} &
  \multicolumn{1}{|r}{81.08} &
  \multicolumn{1}{r}{12.88} &
  \multicolumn{1}{r}{40} &
  \multicolumn{1}{r}{146} \\
\multicolumn{1}{l}{\hspace{2em}Serum cholesterol (mg/dL)} &
  \multicolumn{1}{|r}{213.65} &
  \multicolumn{1}{r}{49.44} &
  \multicolumn{1}{r}{84} &
  \multicolumn{1}{r}{828} \\
\multicolumn{1}{l}{\hspace{2em}Serum triglycerides (mg/dL)} &
  \multicolumn{1}{|r}{146.70} &
  \multicolumn{1}{r}{95.19} &
  \multicolumn{1}{r}{30} &
  \multicolumn{1}{r}{1191} \\
\multicolumn{1}{l}{\hspace{2em}High density lipids (mg/dL)} &
  \multicolumn{1}{|r}{49.38} &
  \multicolumn{1}{r}{13.98} &
  \multicolumn{1}{r}{15} &
  \multicolumn{1}{r}{187} \\
\multicolumn{1}{l}{\hspace{1em}S} &
  \multicolumn{1}{|r}{} &
  \multicolumn{1}{r}{} &
  \multicolumn{1}{r}{} &
  \multicolumn{1}{r}{} \\
\multicolumn{1}{l}{\hspace{2em}Height (cm)} &
  \multicolumn{1}{|r}{167.53} &
  \multicolumn{1}{r}{9.61} &
  \multicolumn{1}{r}{138.5} &
  \multicolumn{1}{r}{200} \\
\multicolumn{1}{l}{\hspace{2em}Weight (kg)} &
  \multicolumn{1}{|r}{72.04} &
  \multicolumn{1}{r}{15.66} &
  \multicolumn{1}{r}{30.84} &
  \multicolumn{1}{r}{158.53} \\
\multicolumn{1}{l}{\hspace{2em}Systolic blood pressure} &
  \multicolumn{1}{|r}{131.16} &
  \multicolumn{1}{r}{24.21} &
  \multicolumn{1}{r}{75} &
  \multicolumn{1}{r}{270} \\
\multicolumn{1}{l}{\hspace{2em}Diastolic blood pressure} &
  \multicolumn{1}{|r}{82.11} &
  \multicolumn{1}{r}{13.44} &
  \multicolumn{1}{r}{38} &
  \multicolumn{1}{r}{148} \\
\multicolumn{1}{l}{\hspace{2em}Serum cholesterol (mg/dL)} &
  \multicolumn{1}{|r}{217.70} &
  \multicolumn{1}{r}{49.29} &
  \multicolumn{1}{r}{80} &
  \multicolumn{1}{r}{471} \\
\multicolumn{1}{l}{\hspace{2em}Serum triglycerides (mg/dL)} &
  \multicolumn{1}{|r}{140.20} &
  \multicolumn{1}{r}{83.48} &
  \multicolumn{1}{r}{25} &
  \multicolumn{1}{r}{768} \\
\multicolumn{1}{l}{\hspace{2em}High density lipids (mg/dL)} &
  \multicolumn{1}{|r}{49.01} &
  \multicolumn{1}{r}{14.73} &
  \multicolumn{1}{r}{16} &
  \multicolumn{1}{r}{157} \\
\multicolumn{1}{l}{\hspace{1em}W} &
  \multicolumn{1}{|r}{} &
  \multicolumn{1}{r}{} &
  \multicolumn{1}{r}{} &
  \multicolumn{1}{r}{} \\
\multicolumn{1}{l}{\hspace{2em}Height (cm)} &
  \multicolumn{1}{|r}{167.89} &
  \multicolumn{1}{r}{9.80} &
  \multicolumn{1}{r}{135.5} &
  \multicolumn{1}{r}{198.199} \\
\multicolumn{1}{l}{\hspace{2em}Weight (kg)} &
  \multicolumn{1}{|r}{71.79} &
  \multicolumn{1}{r}{15.39} &
  \multicolumn{1}{r}{36.06} &
  \multicolumn{1}{r}{175.88} \\
\multicolumn{1}{l}{\hspace{2em}Systolic blood pressure} &
  \multicolumn{1}{|r}{130.59} &
  \multicolumn{1}{r}{22.42} &
  \multicolumn{1}{r}{78} &
  \multicolumn{1}{r}{260} \\
\multicolumn{1}{l}{\hspace{2em}Diastolic blood pressure} &
  \multicolumn{1}{|r}{81.85} &
  \multicolumn{1}{r}{12.05} &
  \multicolumn{1}{r}{40} &
  \multicolumn{1}{r}{140} \\
\multicolumn{1}{l}{\hspace{2em}Serum cholesterol (mg/dL)} &
  \multicolumn{1}{|r}{219.34} &
  \multicolumn{1}{r}{49.79} &
  \multicolumn{1}{r}{83} &
  \multicolumn{1}{r}{644} \\
\multicolumn{1}{l}{\hspace{2em}Serum triglycerides (mg/dL)} &
  \multicolumn{1}{|r}{144.05} &
  \multicolumn{1}{r}{114.79} &
  \multicolumn{1}{r}{16} &
  \multicolumn{1}{r}{2238} \\
\multicolumn{1}{l}{\hspace{2em}High density lipids (mg/dL)} &
  \multicolumn{1}{|r}{50.51} &
  \multicolumn{1}{r}{14.19} &
  \multicolumn{1}{r}{22} &
  \multicolumn{1}{r}{139} \\
\multicolumn{1}{l}{\hspace{1em}Total} &
  \multicolumn{1}{|r}{} &
  \multicolumn{1}{r}{} &
  \multicolumn{1}{r}{} &
  \multicolumn{1}{r}{} \\
\multicolumn{1}{l}{\hspace{2em}Height (cm)} &
  \multicolumn{1}{|r}{167.65} &
  \multicolumn{1}{r}{9.66} &
  \multicolumn{1}{r}{135.5} &
  \multicolumn{1}{r}{200} \\
\multicolumn{1}{l}{\hspace{2em}Weight (kg)} &
  \multicolumn{1}{|r}{71.90} &
  \multicolumn{1}{r}{15.36} &
  \multicolumn{1}{r}{30.84} &
  \multicolumn{1}{r}{175.88} \\
\multicolumn{1}{l}{\hspace{2em}Systolic blood pressure} &
  \multicolumn{1}{|r}{130.88} &
  \multicolumn{1}{r}{23.33} &
  \multicolumn{1}{r}{65} &
  \multicolumn{1}{r}{300} \\
\multicolumn{1}{l}{\hspace{2em}Diastolic blood pressure} &
  \multicolumn{1}{|r}{81.72} &
  \multicolumn{1}{r}{12.93} &
  \multicolumn{1}{r}{35} &
  \multicolumn{1}{r}{150} \\
\multicolumn{1}{l}{\hspace{2em}Serum cholesterol (mg/dL)} &
  \multicolumn{1}{|r}{217.67} &
  \multicolumn{1}{r}{49.39} &
  \multicolumn{1}{r}{80} &
  \multicolumn{1}{r}{828} \\
\multicolumn{1}{l}{\hspace{2em}Serum triglycerides (mg/dL)} &
  \multicolumn{1}{|r}{143.90} &
  \multicolumn{1}{r}{96.50} &
  \multicolumn{1}{r}{16} &
  \multicolumn{1}{r}{2238} \\
\multicolumn{1}{l}{\hspace{2em}High density lipids (mg/dL)} &
  \multicolumn{1}{|r}{49.64} &
  \multicolumn{1}{r}{14.31} &
  \multicolumn{1}{r}{15} &
  \multicolumn{1}{r}{187} \\
\cline{1-5}
\end{tabular}
\end{table}
\end{document}

Here is a partial screenshot of the PDF produced by the following command on
my Mac.

$ pdflatex table