How to export a table of only number of observations to Latex?

[Viktor Marinkov]

I would like to export to Latex a table for a few variables where the first row is the labels of the variables and the second row is their respective number of observations. I ran

estpost tabstat t1p t2p t3p t4p t5p t6p t7p t8p, statistics(n)

and got something similar but not using the variables' labels. Running

esttab

then gives me a result I don't even understand.

How can I get a table as above saved in a .tex file? Many thanks

[Andrew Musau]

estout is from SSC (FAQ Advice #12). Provide an example of

dataex t1p t2p t3p t4p t5p t6p t7p t8p

[Viktor Marinkov]

Here it is:

* Example generated by -dataex-. For more info, type help dataex
clear
input float(t1p t2p t3p t4p t5p t6p t7p t8p)
1.1818181         .  1.567091         .         .         .         .         .
        .  1.453148         .         .         .         .         .         .
        .       .99         .      1.41         .         .         .         .
     1.01         .      1.37         .         .         .         .         .
     1.02         .      1.35         .         .         .         .         .
        .      1.27         .         .         .         .         .         .
        .      1.31         .      1.89         .         .         .         .
     1.15         .       1.7         .         .         .         .         .
     1.05         .       1.5         .         .         .         .         .
        .      1.55         .         .         .         .         .         .
        .      1.99         .      2.89         .         .         .         .
     1.96         .      2.85         .         .         .         .         .
     2.05         .      2.84         .         .         .         .         .
        .      2.82         .         .         .         .         .         .
        .      3.02         .       3.6         .         .         .         .
     3.09         .      3.69         .         .         .         .         .
     3.17         .      3.77         .         .         .         .         .
        .      3.88         .         .         .         .         .         .
        .      3.83         .      4.11         .         .         .         .
     4.03         .      4.33         .         .         .         .         .
     3.97         .       4.3         .         .         .         .         .
        .      4.49         .         .         .         .         .         .
        .  4.751818         . 4.7339287         .         .         .         .
     4.81         .      4.78         .         .         .         .         .
     4.92         .      4.92         .         .         .         .         .
        .      5.16         .         .         .         .         .         .
        .      5.37         .      5.18         .         .         .         .
     5.39         .      5.19         .         .         .         .         .
     5.34         .      5.15         .         .         .         .         .
        .      5.02         .         .         .         .         .         .
        .      5.01         .      4.83         .         .         .         .
     5.19         .         5         .         .         .         .         .
     5.17         .      4.98         .         .         .         .         .
        .      5.04         .         .         .         .         .         .
        .      5.16         .      5.09         .         .         .         .
 5.099967         .  5.025238         .         .         .         .         .
 4.611111         . 4.5194445         .         .         .         .         .
        . 4.4546294         .         .         .         .         .         .
        . 3.8366134         .         .         .         .         .         .
3.6333334         .  3.649074         .         .         .         .         .
2.0590909         . 2.1090908         .         .         .         .         .
        . 1.8645455         .         .         .         .         .         .
        . 2.0324075         . 2.5462964         .         .         .         .
2.1084905         .   2.54717         .         .         .         .         .
  2.02451         .  2.392157         .         .         .         .         .
        . 1.4682692         .         .         .         .         .         .
        .  .5416667         .         .         .         .         .         .
 .2258182         .  .4262727         .         .         .         .         .
 .1782653         .  .2777551         .         .         .         .         .
        .  .2436038         .         .         .         .         .         .
        . .27278847         .    .60375         .  1.220096         .         .
 .1887234         .  .3951064         .  .9294681         .         .         .
 .1964706         .  .4387255         . 1.0387843         .         .         .
        .  .3811458         .  .9647917         .         .         .         .
        .  .3861765         . 1.0360785         .         .         .         .
  .319375         .  .9469643         .         .         .         .         .
.21796297         .  .7855555         .         .         .         .         .
        .  .7501786         .         .         .         .         .         .
        .  .3362264         . 1.1462264         . 2.0622642         .         .
.18103774         .  .4359434         . 1.2036792         .         .         .
 .1581132         .  .3533019         .  .9327359         .         .         .
        . .27845454         .  .7014545         .         .         .         .
        . .20727272         .  .4586364         .         .         .         .
.19517857         .  .3952678         .         .         .         .         .
.17226414         .  .3886792         .         .         .         .         .
        .  .3728182         .         .         .         .         .         .
        . .27141508         .  .7138208         . 1.5057547         .         .
.14270833         . .20958333         .  .3870833         .         .         .
.13113208         .  .1528302         . .20566037         .         .         .
        .      .142         .        .2         .         .         .         .
        . .14657408         .  .1837963         .  .3236274         .  .6443138
.13148148         . .15833333         .  .2645283         . .56817305         .
    .1244         .      .148         .   .241875         . .47677085         .
        . .14509805         .     .2246         .      .463         .  .9604762
        . .13088235         . .18931372         .  .4137255         .  .8245349
    .1106         .     .1525         .    .32035         .  .6427222         .
    .1275         .  .1537766         . .26909575         .  .4513372         .
        .  .1586979         .  .2334896         .  .3984659         .     .5725
        . .15918367         .  .2034694         .  .3256522         .  .4526087
.15091836         . .17989796         .   .269375         .  .4021875         .
    .1324         .     .1641         .     .2389         .  .3782653         .
        . .17040816         . .26229167         .  .4271875         .  .8659756
        . .15923913         . .23358695         .  .3592391         .  .8317105
.16542554         . .18648936         . .30957446         .   .765625         .
.14413044         . .18413043         . .28844443         .  .7935526         .
        . .17683673         .   .242551         .    .56625         .  1.181375
        . .15955555         . .20333333         . .45302325         .  .9444186
.18285714         .  .2537755         .  .4695918         .   .985851         .
 .1282653         . .15744898         .   .404898         .  .9714583         .
        .   .156875         .  .4213542         . 1.0545745         .  1.743684
        . .14583333         .  .3901042         .  1.038125         . 1.7392105
.13936171         .  .4112766         . 1.0973912         . 1.8974285         .
.16802083         .  .4730208         .  1.169375         .     1.934         .
        . .41413045         . 1.0911957         . 1.7779268         .  2.433214
        .      .349         .  .9567778         . 1.5759302         . 2.2313952
end

Obviously they are not too many observations and I could make a manual table in Latex, but I want to automate the process for better replication and future robustness.

[Andrew Musau]

Thanks for the data example. In Stata, variable labels are different from variable names, see

help labels

Here is a way to get what you asked for:

* Example generated by -dataex-. For more info, type help dataex
clear
input float(t1p t2p t3p t4p t5p t6p t7p t8p)
1.1818181         .  1.567091         .         .         .         .         .
        .  1.453148         .         .         .         .         .         .
        .       .99         .      1.41         .         .         .         .
     1.01         .      1.37         .         .         .         .         .
     1.02         .      1.35         .         .         .         .         .
        .      1.27         .         .         .         .         .         .
        .      1.31         .      1.89         .         .         .         .
     1.15         .       1.7         .         .         .         .         .
     1.05         .       1.5         .         .         .         .         .
        .      1.55         .         .         .         .         .         .
        .      1.99         .      2.89         .         .         .         .
     1.96         .      2.85         .         .         .         .         .
     2.05         .      2.84         .         .         .         .         .
        .      2.82         .         .         .         .         .         .
        .      3.02         .       3.6         .         .         .         .
     3.09         .      3.69         .         .         .         .         .
     3.17         .      3.77         .         .         .         .         .
        .      3.88         .         .         .         .         .         .
        .      3.83         .      4.11         .         .         .         .
     4.03         .      4.33         .         .         .         .         .
     3.97         .       4.3         .         .         .         .         .
        .      4.49         .         .         .         .         .         .
        .  4.751818         . 4.7339287         .         .         .         .
     4.81         .      4.78         .         .         .         .         .
     4.92         .      4.92         .         .         .         .         .
        .      5.16         .         .         .         .         .         .
        .      5.37         .      5.18         .         .         .         .
     5.39         .      5.19         .         .         .         .         .
     5.34         .      5.15         .         .         .         .         .
        .      5.02         .         .         .         .         .         .
        .      5.01         .      4.83         .         .         .         .
     5.19         .         5         .         .         .         .         .
     5.17         .      4.98         .         .         .         .         .
        .      5.04         .         .         .         .         .         .
        .      5.16         .      5.09         .         .         .         .
 5.099967         .  5.025238         .         .         .         .         .
 4.611111         . 4.5194445         .         .         .         .         .
        . 4.4546294         .         .         .         .         .         .
        . 3.8366134         .         .         .         .         .         .
3.6333334         .  3.649074         .         .         .         .         .
2.0590909         . 2.1090908         .         .         .         .         .
        . 1.8645455         .         .         .         .         .         .
        . 2.0324075         . 2.5462964         .         .         .         .
2.1084905         .   2.54717         .         .         .         .         .
  2.02451         .  2.392157         .         .         .         .         .
        . 1.4682692         .         .         .         .         .         .
        .  .5416667         .         .         .         .         .         .
 .2258182         .  .4262727         .         .         .         .         .
 .1782653         .  .2777551         .         .         .         .         .
        .  .2436038         .         .         .         .         .         .
        . .27278847         .    .60375         .  1.220096         .         .
 .1887234         .  .3951064         .  .9294681         .         .         .
 .1964706         .  .4387255         . 1.0387843         .         .         .
        .  .3811458         .  .9647917         .         .         .         .
        .  .3861765         . 1.0360785         .         .         .         .
  .319375         .  .9469643         .         .         .         .         .
.21796297         .  .7855555         .         .         .         .         .
        .  .7501786         .         .         .         .         .         .
        .  .3362264         . 1.1462264         . 2.0622642         .         .
.18103774         .  .4359434         . 1.2036792         .         .         .
 .1581132         .  .3533019         .  .9327359         .         .         .
        . .27845454         .  .7014545         .         .         .         .
        . .20727272         .  .4586364         .         .         .         .
.19517857         .  .3952678         .         .         .         .         .
.17226414         .  .3886792         .         .         .         .         .
        .  .3728182         .         .         .         .         .         .
        . .27141508         .  .7138208         . 1.5057547         .         .
.14270833         . .20958333         .  .3870833         .         .         .
.13113208         .  .1528302         . .20566037         .         .         .
        .      .142         .        .2         .         .         .         .
        . .14657408         .  .1837963         .  .3236274         .  .6443138
.13148148         . .15833333         .  .2645283         . .56817305         .
    .1244         .      .148         .   .241875         . .47677085         .
        . .14509805         .     .2246         .      .463         .  .9604762
        . .13088235         . .18931372         .  .4137255         .  .8245349
    .1106         .     .1525         .    .32035         .  .6427222         .
    .1275         .  .1537766         . .26909575         .  .4513372         .
        .  .1586979         .  .2334896         .  .3984659         .     .5725
        . .15918367         .  .2034694         .  .3256522         .  .4526087
.15091836         . .17989796         .   .269375         .  .4021875         .
    .1324         .     .1641         .     .2389         .  .3782653         .
        . .17040816         . .26229167         .  .4271875         .  .8659756
        . .15923913         . .23358695         .  .3592391         .  .8317105
.16542554         . .18648936         . .30957446         .   .765625         .
.14413044         . .18413043         . .28844443         .  .7935526         .
        . .17683673         .   .242551         .    .56625         .  1.181375
        . .15955555         . .20333333         . .45302325         .  .9444186
.18285714         .  .2537755         .  .4695918         .   .985851         .
 .1282653         . .15744898         .   .404898         .  .9714583         .
        .   .156875         .  .4213542         . 1.0545745         .  1.743684
        . .14583333         .  .3901042         .  1.038125         . 1.7392105
.13936171         .  .4112766         . 1.0973912         . 1.8974285         .
.16802083         .  .4730208         .  1.169375         .     1.934         .
        . .41413045         . 1.0911957         . 1.7779268         .  2.433214
        .      .349         .  .9567778         . 1.5759302         . 2.2313952
end

estpost tabstat t1p t2p t3p t4p t5p t6p t7p t8p, statistics(n)
esttab using myfile.tex, replace cells("t1p t2p t3p t4p t5p t6p t7p t8p") wide noobs nonumbers mlab(none)

Res.:

. esttab, cells("t1p t2p t3p t4p t5p t6p t7p t8p") wide noobs nonumbers mlab(none) compress

------------------------------------------------------------------------------------------
                 t1p       t2p       t3p       t4p       t5p       t6p       t7p       t8p
------------------------------------------------------------------------------------------
count             47        48        47        31        18        16        12        13
------------------------------------------------------------------------------------------