[Asdoc] Appending 2 tables (with the same row header) into 1

[Hannah Nguyen]

I want to run some descriptive statistics of sch_q2 by county_name and by SES. After running the below code, I have 2 separate tables with the same row header. Is there any way to append these 2 tables?

asdoc tab sch_q2 county_name, replace save(headteacher)
asdoc tab sch_q2 SES, append save(headteacher)

Append into one table like that

Thank you in advance

[Attaullah Shah]

This is not possible in asdoc. However, the enhanced version of asdoc, i.e. asdocx plus flexmat (which is part of the asdocx system or can be downloaded from SSC) can do it. See the following example.

* Load example data
sysuse nlsw88

* Create the tables independently
asdocx tab married race, replace
asdocx tab married south

* Each table is stored in location 1, 2 and  respectively of the flexmat file system
* Us the flexmat sub-command merge to merge the two tables
flexmat merge, matloc(1,2)

asdocx export

Several user-written commands and Stata official commands for tabulation of categorical variables are supported in asdocx.

• tabmany – Table of multiple coded answers
• mrtab – One- and two-way tables of multiple responses
• tab3way – Three way table of frequencies and percentages
• tabcount – Tabulates frequencies for up to 7 variables
• missings – Various utilities for managing missing values
• tabulate, tab1, tab2
• pctab – Percentage over a grouping variable