asdocx: Export from Stata to Word, Excel, LaTeX & HTML Forums asdocx Forum asdocx: export tables from Gtools – Gstats tab | Stata Reply To: asdocx: export tables from Gtools – Gstats tab | Stata

Attaullah Shah
Moderator
Post count: 70

Here is something you can work with. I tried to find the colvector for variable names, but did not find. But I was in hurry, you may find it somewhere in the gtools documentations.

sysuse auto, clear
gstats tab price mpg, by(foreign strvar) matasave

* Get the statistics matrix from the GstatsOutput class
* Note: We need to convert the real matrix to string first
mata stat_values = strofreal(GstatsOutput.output)

* Get the names of the statistics
mata stat_names = GstatsOutput.statnames

* Combine the two matrices
mata outtable = stat_names \ stat_values

* Add the matrix to asdocx system
flexmat reset
flexmat addmat, matname(outtable) 

* Export to word
asdocx export

  0 |1            2             3          4          5             6 
----+------------------------------------------------------------------
  1 |n          sum          mean        min        max            sd 
----+------------------------------------------------------------------
  2 |4        19162        4790.5       3799       6486      1169.903 
  3 |4           93         23.25         19         26       3.40343 
  4 |2         9129        4564.5       4195       4934      522.5519 
  5 |2           42            21         18         24      4.242641 
  6 |8        47741      5967.625       3667      14500      3579.357 
  7 |8          153        19.125         14         24      3.758324 
  8 |27      178391      6607.074       3291      15906      3661.267 
  9 |27         513            19         12         29      4.085622 
 10 |9        52934      5881.556       3829       8814      1592.019 
 11 |9          166      18.44444         14         28      4.585605 
 12 |2         8409        4204.5       3984       4425      311.8341 
 13 |2           64            32         30         34      2.828427 
 14 |1        12990         12990      12990      12990             . 
 15 |1           14            14         14         14             . 
 16 |3        14486      4828.667       3895       6295      1285.613 
 17 |3           70      23.33333         21         26      2.516611 
 18 |9        56353      6261.444       3995       9735      1896.092 
 19 |9          224      24.88889         21         30      2.713137 
 20 |9        56634      6292.667       3748      11995      2765.629 
 21 |9          237      26.33333         17         41      9.367497 
-----------------------------------------------------------------------