Table of descriptive statistics for word

[Guest]

Hi,

to export the table of descriptive statistics I am using the "asdoc" command. With this command, I only receive the mean, standard deviation, min and max values of my variables. But I also want to show the median of my choosen variables. So far I tried:


"asdoc sum leverage1 leverage2 leverage3 leverage5 leverage4 logAssets Tangibility1 Liquidity Profitability Growth Revenues_w if post==0,stat(mean sd p50) append title(Descriptive Statistics) save(Descriptive Statistics.doc)"

With this command, I only get the values at the 1st and 99th percentile. I am confused how to solve this issue.

[Carlo Lazzaro]

Guest:
you can take advantage of the -table- suite:

. use "C:\Program Files\Stata18\ado\base\a\auto.dta"
(1978 automobile data)

. table (var) ( foreign ), stat(mean rep78 ) statistic(sd rep78 ) statistic(median rep78 )

------------------------------------------------------
                     |            Car origin          
                     |  Domestic    Foreign      Total
---------------------+--------------------------------
Repair record 1978   |                                
  Mean               |  3.020833   4.285714   3.405797
  Standard deviation |   .837666   .7171372   .9899323
  Median             |         3          4          3
------------------------------------------------------

. table (var) ( foreign ), stat(mean rep78 ) statistic(sd rep78 ) statistic(median rep78 )  statistic(iqr rep78 )

-------------------------------------------------------
                      |            Car origin          
                      |  Domestic    Foreign      Total
----------------------+--------------------------------
Repair record 1978    |                                
  Mean                |  3.020833   4.285714   3.405797
  Standard deviation  |   .837666   .7171372   .9899323
  Median              |         3          4          3
  Interquartile range |         0          1          1
-------------------------------------------------------

. putdocx begin

. putdocx collect


. putdocx save Stata_Table_Example, replace


.

[Maxence Morlet]

In addition to Carlo's extremely accurate and excellent advice, you may want to check the dtable command if you are using Stata18.

[Guest]

Thank you Carlo and Maxence! Both advices were very helpful.

[Attaullah Shah]

To report custom summary statistics, use the option stat() and supply the required statistics inside the stat() option, see more on this on the asdoc web page. Here is one example:

sysuse auto
asdoc sum price mpg rep78 headroom, stat(p1 mean sd p50 p99)