Add frequency column in esttab table

[Sara Gregori]

Hi everyone,

I am trying to replicate a table of summary statistics for Latex with different variables in the rows and I would like 2 columns, one with the percentage and one with the frequency. My code is:

qui regress y i.F1 i.F2 i.F3 i.F4 i.F5 i.fl_count i.big3_count i.one_dont_know [pw=Gewicht_Cor3]

eststo test2: proportion F1 F2 F3 F4 F5 fl_count big3_count one_dont_know [pw=Gewicht_Cor3]
estadd summ

estadd matrix pc = e(mean)*100

esttab test2 using test2.tex, refcat(0.F1 \textbf{Compound} 0.F2 \textbf{Inflation} 0.F3 \textbf{Risk} 0.F4 \textbf{Compound} 0.F5 \textbf{Loan} 0.big3_count \textbf{Others}, nolabel) wide cells("pc(fmt(%-9.1f))") replace label title(\textbf{Table 2.} Summary statistics for the Big Five financial literacy questions) nonumbers mtitles(" ") addnote(Note: All figures are weighted.) collabels(Percent)

but when I try to add the cell "count" together with the pc the column in the output stays blank.

Do you have any idea how could I add this column?

Thank you.

[Andrew Musau]

estout is from SSC (FAQ Advice #12). Add a data example that we can use with your code. Or create another reproducible example. See FAQ Advice #12 for details.