I am running different summary statistics based on the if condition. Then I am trying to export them to LaTeX using esttab. After running each tabstat command, I store the results. Then in the last line of code, I export the stored results to LaTeX.
However, instead of getting added to the same column, I am getting new columns. The codes that I am using:
Code:
eststo clear
estpost tabstat pscpoa pscpcr pstpoa pstpcr if year>=1992 & elec_scres>=1995 & majstate==1, listwise statistics(n mean sd min max) columns(statistics)
eststo sum_2
estpost tabstat parrest_womcrime parrest_rape parrest_womgirl parrest_nonwomen parrest_kidmen if year>=1988 & majstate==1, listwise statistics(n mean sd min max ) columns(statistics)
eststo sum_3
estpost tabstat charge_womcrime chargesheet_rate if year>=1991 & majstate==1, listwise statistics(n mean sd min max) columns(statistics)
eststo sum_4
estpost tabstat pfemale prural plit pfarm womancm ppol_strength pcgsdp if year>=1985 & majstate==1, listwise statistics(n mean sd min max) columns(statistics)
eststo sum_5
esttab sum_* using "sumstatstable2.tex", replace cells("mean(fmt(%6.2fc)) sd(fmt(%6.2fc)) min max count") nostar nonumber unstack nonote noobs label ///
collabels (collabels("Mean" "SD" "Min" "Max" "N")) ///
nomtitlesThe snippet of the data set
Code:
* Example generated by -dataex-. For more info, type help dataex
clear
input float(pscpoa pscpcr pstpoa pstpcr parrest_womcrime parrest_rape parrest_womgirl parrest_nonwomen parrest_kidmen charge_womcrime chargesheet_rate pfemale prural plit pfarm womancm ppol_strength pcgsdp)
. . . . .06736186 .009807092 0 .01116854 0 . . .9738747 .7506105 .3305793 .29363903 0 .9231606 .9672344
. . . . .06176531 .009078969 0 .012011826 0 . . .9735454 .7469991 .3375242 .29360288 0 .9650528 .9292045
. . . . .06926454 .011447269 0 .013769825 0 . . .9732302 .7435403 .3441757 .29356825 0 .8814723 1.0234834
. . . . .10067802 .012008846 .010060602 .013046685 .006212023 . . .9729281 .7402247 .3505519 .29353505 0 .8370261 1.1599562
. . . . .11604038 .013783643 .01173409 .013540277 .00815128 . . .9726384 .7370435 .3566695 .29350322 0 .8655064 1.2203605
. . . . .08734287 .01110222 .010688188 .010458738 .011761608 . . .9723602 .7339888 .362544 .29347265 0 1.2400752 1.2487357
. . . . .08049799 .013472062 .007803571 .010383066 .01102123 88.8 83.5 .9720929 .7310531 .3681896 .29344326 0 .9678233 1.2946144
0 .026470186 0 .004670776 .0889 .015649498 .010166246 .01208353 .008032223 89.45 84 .9727665 .7305899 .3857873 .2858227 0 .9986335 1.257861
0 .02531624 0 .0011456314 .0987464 .016523395 .009817613 .012594742 .005799989 92.1 85.06 .9734213 .73014 .4028861 .27841815 0 1.0344287 1.3742623
.02761696 .02140989 .00944485 .0022487738 .0767812 .015168844 .00943551 .011869353 .008729648 88.64999 85.8 .9740582 .7297026 .4195069 .2712206 0 1.032 1.4310932
.04596532 .023469767 .009272894 .0015454824 .3613092 .015215487 .008737184 .013034274 .012459368 94.23334 86.32 .974678 .7292773 .4356696 .26422143 0 1.0338434 1.4948517
.04395648 .02433305 .016479492 .0010841772 .4116878 .015120726 .017236786 .013811248 .007399206 96.61667 88.55 .9752814 .7288635 .4513928 .2574126 0 1.0189463 1.567477
.05455022 .022850957 .01235553 .001278158 .446436 .019024126 .012055987 .012208139 .008917559 95.83334 87.19 .9758688 .7284608 .46669415 .25078645 0 1.0197817 1.5252533
.04536447 .013372363 .011514184 .0018841393 .4808791 .01551172 .010532145 .00621237 .008349317 95.21667 86.62 .9764411 .7280688 .48159045 .2443357 0 1.0217545 1.6880356
.04353563 .022184825 .008026047 .0014405724 .5076185 .017247971 .012575803 .007429513 .012764306 95.63333 86.47 .9769987 .7276871 .4960976 .23805347 0 .996141 1.7423385
.04348562 .023345776 .016796038 .0012141714 .56532633 .016586965 .010712414 .009022272 .009157387 96.75 88.6 .9775423 .7273151 .51023054 .23193327 0 .7840264 1.8564473
.07698724 .02528423 .02567622 .005175052 .5896091 .015089882 .01266238 .008758731 .009552551 92.7 88.9 .9780723 .7269527 .5240037 .2259689 0 1.0214669 1.9097586
.06632322 .036677543 .026240725 .007637226 .6975439 .017361965 .012464335 .0088755395 .008162715 97.47143 87 .9785892 .7265993 .5374305 .22015446 0 .9948924 1.9471388
.0972478 .01300315 .028907144 .0040470003 .67316 .015828453 0 .008516628 0 97.11429 82.2 .9790936 .7262548 .550524 .2144844 0 .9468793 2.101248
.10253422 .00528607 .02788585 .0007587986 .7400834 .01823798 .01396602 .008297004 .010313368 95.58572 85.9 .9795858 .7259187 .5632964 .2089534 0 .9839409 2.2199104
.09540783 .004678358 .036608465 0 .7854244 .017667446 .015357568 .008725246 .011561876 97.11429 86.1 .9800664 .7255906 .57575935 .2035564 0 .9793633 2.3842545
.11457956 .007038243 .05481553 .0022073367 .7639755 .016777487 .01635805 .009885357 .009622382 82.42857 88.7 .9805357 .7252705 .58792394 .1982886 0 .9782262 2.564784
.08963057 .009112441 .05490246 .0005435888 .8645788 .017505534 .02040687 .01119262 .01134934 96.4 88.3 .9809941 .724958 .5998008 .1931454 0 .9583914 2.7574174
. . . . .04144665 .019823115 0 .002873704 0 . . .916738 .894 .3932999 .1937285 0 2.0428765 1.1879473
. . . . .03930586 .01739383 0 .002996673 0 . . .9178158 .8930889 .399007 .19423166 0 2.0578952 1.1376076
. . . . .05887507 .02670632 0 .002909982 0 . . .9188545 .8922119 .4045009 .194716 0 2.225159 1.1800961
. . . . .14018343 .01878005 .04725607 .00288022 .0022121866 . . .9198561 .8913671 .4097934 .1951826 0 1.936652 1.1714164
. . . . .17026953 .02528263 .05121235 .002943878 .002727012 . . .9208226 .8905526 .41489545 .19563243 0 1.9056727 1.2352266
. . . . .14369473 .02165734 .0449492 .0027687345 .004086291 . . .921756 .889767 .419817 .1960663 0 1.876788 1.263168
. . . . .14094022 .021147193 .04398973 .002266185 .00865518 67.75 52 .9226577 .8890087 .4245675 .19648513 0 1.8784418 1.298276
0 0 0 0 .16018528 .02355677 .05061641 .002484539 .007487376 74.2 54.8 .9240646 .8869039 .4363822 .188074 0 1.9456668 1.2918975
0 0 0 0 .1667149 .02531965 .05055333 .002582991 .007221904 64.05 53.18 .9254222 .8848758 .447766 .17996956 0 1.9453144 1.3203588
0 0 0 0 .15649988 .02663944 .04411761 .002285419 .008316909 65.65 51.77 .926733 .8829204 .4587422 .17215537 0 1.9104404 1.33348
0 0 0 0 .2799608 .02554871 .0459545 .0020059887 .008917164 72.98333 51.57 .9279993 .8810337 .4693322 .16461606 0 2.0180993 1.3474033
0 0 0 0 .2657096 .02734877 .03533738 .001916737 .01055638 73.13333 51.05 .9292235 .8792123 .4795561 .15733743 0 1.9832138 1.3629392
0 0 0 0 .28105608 .028967453 .03982524 .0019238315 .010817721 72.15 55.42 .9304075 .8774528 .4894326 .15030615 0 1.949674 1.3530676
0 0 0 0 .3415335 .03277763 .04971799 .002097335 .023204355 79.48333 55.22 .9315534 .875752 .4989789 .14350985 0 2.0215366 1.32756
0 .00055783597 0 0 .370321 .03181272 .05196207 .0020467087 .016971951 70.65 54.29 .9326628 .8741072 .50821155 .13693693 0 2.0370991 1.347282
.00055270136 0 0 0 .3902489 .030383425 .05535349 .0019084375 .019289853 71.85 53.9 .9337377 .8725156 .51714563 .13057655 0 2.0868876 1.361537
0 0 0 0 .4268357 .03481454 .05938731 .0019386973 .022134246 71.66667 50.1 .9347795 .8709746 .5257954 .12441858 0 2.0012734 1.374636
0 0 0 0 .5167024 .03762973 .07263757 .0019125063 .01887026 71.73334 59.8 .9357896 .8694819 .5341742 .1184535 0 1.9687848 1.7561967
0 0 0 .0002945165 .4089327 .04319408 0 .0022633625 0 68.13333 58.9 .9367697 .8680352 .5422946 .11267239 0 1.8924315 1.8228494
0 0 0 0 .6005858 .04414941 .07458494 .0022091896 .017115507 69.083336 59.2 .9377209 .8666325 .5501684 .10706686 0 1.8636925 1.90057
0 0 0 0 .6381419 .04959084 .07935945 .0022527855 .021021437 77.2 62.6 .9386446 .8652717 .5578066 .10162905 0 1.8358134 2.010044
0 0 0 0 .6053271 .04482882 .06421989 .001887328 .01091182 76.38333 62.3 .9395419 .863951 .56521964 .09635152 0 1.808756 2.121233
0 .0005192455 0 0 .6216177 .05058176 .05893785 .0018664565 .01537658 73.333336 58.9 .9404138 .8626688 .5724173 .0912273 0 1.7824847 2.2417316
. . . . .02609914 .0125231 0 .002919569 0 . . .9298745 .8722513 .28175357 .23681992 0 .9005913 .4330461
. . . . .032013178 .01426842 0 .002944196 0 . . .9263416 .8715714 .28616118 .23729387 0 .8895688 .4524605
. . . . .03574684 .016204922 0 .002755739 0 . . .9229666 .8709195 .29038695 .23774827 0 .9075508 .4258182
. . . . .1125182 .016122982 .02969183 .002802059 .00760101 . . .9197391 .870294 .29444188 .2381843 0 .9493895 .4665741
. . . . .11851092 .016850717 .02673246 .0026840905 .01142238 . . .9166497 .8696933 .29833615 .23860303 0 .9305809 .4522493
. . . . .13712022 .019296933 .02817234 .0030806756 .019957867 . . .9136897 .8691159 .3020791 .2390055 0 .8889925 .48544425
. . . . .12787701 .014599222 .02625776 .003215441 .020167997 75.3 64.6 .9108511 .8685606 .3056794 .23939264 0 .8825178 .4569518
0 .0006956143 0 .0002967463 .12960391 .019621 .021751024 .00311362 .03916311 82.55 67.6 .9125316 .8683075 .3161369 .23170254 0 .8460134 .4258708
0 .0017287112 0 0 .1623181 .019618297 .036085807 .0028924746 .02212136 83.95 67.07 .9141278 .8680676 .3260532 .2244104 0 .8639955 .7096417
.007607225 .0005120248 .0008589263 .00014315438 .12533216 .01993677 .007961866 .0025553845 .04095438 85.9 69.78 .915646 .8678398 .3354692 .21748616 0 .8529257 .7372998
.01211023 .0002849466 .0021102044 .0004220409 .1398004 .02033352 .01529189 .0026456744 .027629783 73.55 64.7 .9170917 .8676232 .3444219 .2109026 0 .8363568 .6945373
.0095111 0 .00497845 0 .23847756 .021465085 .01677883 .002485223 .02709878 89.68333 73.47 .91847 .8674169 .3529447 .2046352 0 .8162743 .7118554
.014081907 0 .01332605 0 .235619 .019539103 .013957923 .0023039428 .03100987 85.96667 73.78 .9197855 .8672203 .3610677 .19866176 1 .083658 .7970909
.017770752 .0007927474 .009763447 0 .3022349 .018138804 .013453432 .002365189 .035305537 87.85 73.6 .9210424 .8670328 .3688186 .192962 1 .8068949 .8280303
.01780216 0 .0018421736 0 .25424427 .019272003 .01248689 .0020208806 .02748256 85.58334 77.67 .9222445 .8668537 .3762222 .1875176 1 .901736 .8015464
.013862424 .0003780661 .001942359 0 .26748657 .01996517 .008569781 .0022251408 .029222766 92.37143 79.2 .9233955 .8666824 .3833015 .18231176 1 .881981 .8291109
.03375061 .004988685 .0038238876 .0010197033 .3177855 .018527556 .011878738 .0022505934 .03304399 89.22857 76.60001 .9244983 .8665184 .3900772 .1773291 1 .4129726 .8038365
.04625601 .006805897 .005772897 .0005019911 .3107458 .019385345 .011629427 .0022725733 .034665663 88.91428 77.39999 .925556 .8663614 .3965685 .1725556 1 .6198324 .8547454
.05539267 .004832127 .002966215 .0007415537 .20667657 .016387822 0 .0021125812 0 89.29286 76.35 .9265713 .8662108 .4027929 .16797836 1 .6410438 .8368353
.10763568 .00536448 .007913347 .000608719 .28885543 .016373927 .01659612 .0022205815 .030047353 89.28571 75.05 .9275467 .8660662 .4087666 .1635855 1 .6031861 .959787
.06806847 .005818301 .02530941 .01919197 .2549382 .018320834 .01445059 .0019906464 .035301324 82.60714 73.2 .9284846 .8659274 .4145043 .15936613 1 .6333882 .967429
.08705389 .0007194536 .014539571 .0040190686 .2707161 .01966659 .01921477 .001880887 .032580495 88.94286 71.85 .929387 .8657939 .4200199 .15531014 0 .6603917 1.0630697
.11971291 0 .011185523 0 .3257951 .021775175 .02122717 .0021548315 .027980534 81.67143 73.15 .9302559 .8656656 .4253259 .15140824 0 .7766613 1.1194798
. . . . .0155293 .00549015 0 .00987459 0 . . .9385528 .6738522 .4703156 .19298 0 1.590737 1.2079208
. . . . .016005468 .005544106 0 .008854945 0 . . .9377936 .6704345 .4778442 .19281313 0 1.5708655 1.258367
. . . . .01361248 .006038511 0 .008539105 0 . . .9370635 .6671454 .4850897 .1926525 0 2.0931768 1.1264268
. . . . .04775991 .005824878 .01652937 .008247083 .004445302 . . .9363608 .6639776 .4920677 .1924978 0 1.4306464 1.4953513
. . . . .06019679 .00767594 .02034375 .008851237 .005644073 . . .9356841 .6609247 .4987928 .19234873 0 1.4433275 1.457312
. . . . .06011548 .008032088 .019267157 .009223966 .007194386 . . .935032 .6579804 .5052786 .19220497 0 1.3791785 1.459965
. . . . .07882984 .011062808 .02611985 .009994437 .006124487 87.45 75.5 .9344031 .6551391 .5115375 .1920662 0 1.4280707 1.341453
0 .03789833 0 .0003177774 .07877383 .012024885 .025470033 .010215613 .007906125 87.65 75.6 .9327134 .651693 .52078724 .18739738 0 1.3954074 1.684075
0 .02810382 0 .0003112525 .07727928 .011138935 .02542734 .00950656 .0083136745 87.35 75.13 .9310998 .6483964 .52963597 .18293098 0 1.532518 1.6180042
.2155236 .018012058 .010217167 .0006099801 .08144467 .011038575 .027970435 .009556687 .00727594 85.95 75.66 .9295572 .6452397 .5381091 .1786541 0 1.4773104 1.8690183
.20774136 .029633695 .011510527 0 .06870539 .009499678 .02308333 .009191605 .006947195 87.25 77.19 .928081 .6422142 .5462302 .174555 0 1.455626 1.9306647
.17225122 .03877907 .006450225 .00014659602 .4631123 .00948026 .02076525 .008960673 .010328265 94.68333 69.32 .926667 .6393119 .55402064 .17062274 0 1.4068836 2.160654
.1781185 .03432184 .007046906 0 .52480793 .01148606 .0244212 .006967138 .010740213 91.3 78.31 .9253114 .6365253 .56150025 .1668474 0 1.3680134 2.1622365
.1733174 .007864824 .007762502 0 .59535927 .011574803 .02603286 .007058164 .010363 92.93333 79.07 .9240106 .6338478 .5686873 .1632197 0 1.3287623 2.272139
.1190393 .002581575 .006235033 .0001385563 .6579636 .010758476 .02454982 .007200106 .008463335 93.33334 78.34 .9227614 .6312729 .5755986 .15973122 0 1.249008 2.2513084
.09436417 .0019776921 .003265652 0 .6251799 .009490322 .020951094 .006888325 .009832135 94.68333 80.5 .9215608 .628795 .5822497 .15637405 0 1.199621 2.1010206
.0990894 .0044534565 .01203022 .0004010073 .5544063 .007913794 .02097846 .006609498 .006690215 95.06667 79.6 .9204059 .6264087 .58865505 .15314093 0 1.1907793 2.2355382
.09105992 .0016456613 .0127412 .00013135256 .50824183 .007324565 .019512797 .006904643 .008467817 93.01666 77.2 .9192942 .624109 .594828 .1500251 0 1.1392798 2.3737016
.0865055 .001892308 .008908931 0 .4930888 .006775364 0 .006266089 0 91.73334 74.7 .9182234 .6218911 .600781 .14702033 0 1.0961815 2.67585
.10952926 .0013324727 .007490185 0 .6077446 .008994109 .02189626 .006378992 .007516907 94.6 77 .9171911 .619751 .6065256 .14412072 0 1.0769932 2.823122
.11404073 .0015766 .009114844 0 .6345639 .00920692 .02107852 .006436152 .008821001 93.7 79.6 .9161955 .6176845 .6120726 .14132088 0 1.058465 3.112233
.09303185 .0010365666 .006510375 0 .6876118 .009737725 .020631693 .006289703 .005401818 93.43333 80.5 .9152345 .6156878 .6174319 .13861576 0 1.5171702 3.357936
.0838418 .00051123055 .00531864 0 .8058673 .008936205 .024090445 .006807594 .007319516 92 81.5 .9143064 .6137576 .6226129 .13600062 0 1.291699 3.6638045
. . . . .0270186 .01234393 0 .003684559 0 . . .8678024 .7685806 .40320325 .16924773 0 1.472066 1.741134
. . . . .03282327 .015109099 0 .0036362566 0 . . .8672871 .7658045 .4124005 .16856575 0 1.4537404 1.703264
. . . . .016316537 .007576142 0 .00741897 0 . . .8667963 .7631591 .4211648 .16791587 0 1.239829 1.6492534
. . . . .05818893 .014089684 .012920954 .003715521 .004674918 . . .8663283 .7606353 .42952615 .16729586 0 1.5973936 1.969891
. . . . .05867489 .01459813 .011868915 .0039131874 .008949289 . . .8658816 .758225 .4375116 .1667037 0 1.7868747 1.957462
. . . . .064357944 .01651195 .013221974 .0040767756 .0009932 . . .8654547 .7559206 .44514605 .1661376 0 1.8024718 2.094745
. . . . .06469208 .013544993 .016217548 .0042784563 .003705133 90.75 87 .8650463 .7537153 .4524521 .16559586 0 1.5855538 2.1017241
0 .000599709 . . .0806306 .021498086 .015887322 .004320702 .007264463 90.25 87.9 .8644987 .7483543 .4673754 .16164505 0 1.54172 2.0470438
end
0 Response to Multiple stored results from tabstat and esttab
Post a Comment