asdocx: Export from Stata to Word, Excel, LaTeX & HTML › Forums › asdocx Forum › by() and bysort with tabulate or tab command using asdocx › Reply To: by() and bysort with tabulate or tab command using asdocx
I have now updated asdocx. You can now use bysort or by() with tabulate command. Here is an example:
asdocx_update
sysuse auto, clear
by foreign : asdocx tab rep78, replace
Tabulation of rep78 when foreign is Domestic
0 |1 2 3 4
----+-----------------------------------------------------------------------------
1 |Repair record 1978 Freq. Percent Cum.
----+-----------------------------------------------------------------------------
2 |1 2 4.17 4.17
3 |2 8 16.67 20.83
4 |3 27 56.25 77.08
5 |4 9 18.75 95.83
6 |5 2 4.17 100.00
7 | Total 48 100.00
----------------------------------------------------------------------------------
Tabulation of rep78 when foreign is Foreign
0 |1 2 3 4
----+-----------------------------------------------------------------------------
1 |Repair record 1978 Freq. Percent Cum.
----+-----------------------------------------------------------------------------
2 |3 3 14.29 14.29
3 |4 9 42.86 57.14
4 |5 9 42.86 100.00
5 | Total 21 100.00
----------------------------------------------------------------------------------
Click to Open File: C:\temp\test2.docx
I am not clear on your query related to labels. For me the lables works correctly. You must use the option label to export variable labels.
asdocx sum price mpg rep78 headroom , detail stat(count mean sd var cv p50 skewness) ///
title(something in danish) font(arial) dec(2) replace save(test2.docx) tzok label