Hi All,
I'm now trying to use esttab for generating the table: Could you please explain why I don't get the table output like the below

I run the blew code first !
code:
estpost tabstat new_cases new_deaths new_tests new_vaccinations, c(stat) stat(sum mean sd min max n)

And then,
code:
esttab, ///
cells("sum(fmt(%13.0fc)) mean(fmt(%13.2fc)) sd(fmt(%13.2fc)) min max count") nonumber ///
nomtitle nonote noobs label collabels("Sum" "Mean" "SD" "Min" "Max" "N")

but

the number is only present in N column, and the other columns are blank. Please suggest me! please see the attached file.


Here is sample data :

----------------------- copy starting from the next line -----------------------
Code:
* Example generated by -dataex-. For more info, type help dataex
clear
input long new_cases int new_deaths long(new_tests new_vaccinations)
  5  . . .
  0  . . .
  0  . . .
  0  . . .
  0  . . .
  0  . . .
  0  . . .
  0  . . .
  0  . . .
  0  . . .
  0  . . .
  0  . . .
  3  . . .
  0  . . .
  0  . . .
  0  . . .
  3  . . .
  0  . . .
  0  . . .
  3  . . .
  6  . . .
  5  . . .
  1  . . .
  0  . . .
  0  . . .
  .  . . .
  0  . . .
 10  . . .
  6  1 . .
  2  0 . .
 32  0 . .
  6  1 . .
 11  0 . .
 15  0 . .
  8  2 . .
  0  0 . .
 52  0 . .
 26  0 . .
 43  0 . .
 34  1 . .
  1  0 . .
 29  2 . .
 38  0 . .
 30  4 . .
 56  3 . .
 21  1 . .
 77  0 . .
  0  0 . .
 34  3 . .
 52  1 . .
 58  3 . .
105  3 . .
 24  4 . .
 51  1 . .
 63  0 . .
 25  0 . .
 63  3 . .
 30  3 . .
 66  0 . .
 84  4 . .
 50  0 . .
104  3 . .
133  6 . .
 68  1 . .
172 10 . .
124  0 . .
  0  0 . .
344  4 . .
298  8 . .
  0  0 . .
  0  0 . .
  0  0 . .
755 23 . .
168  9 . .
171  1 . .
  0  0 . .
839 14 . .
262  1 . .
303  7 . .
  0  0 . .
372  9 . .
714 17 . .
349 15 . .
233  1 . .
437  4 . .
583  4 . .
490 10 . .
531  6 . .
540 12 . .
736 10 . .
716  7 . .
512  1 . .
737  1 . .
548  6 . .
637  9 . .
643 11 . .
784  2 . .
651  2 . .
656 15 . .
742  5 . .
end
------------------ copy up to and including the previous line ------------------

Listed 100 out of 110908 observations
Use the count() option to list more

.