Group tables from tabulate command

[Linh Khanh Pham]

I'm running tabulate command for 2 categorical variables in each province. Here is the example of the result:

Is there anyway that I can combine 2 tabulate tables into 1 table for each province???

[Clyde Schechter]

If the cumulative percents are not important (and I presume they are not since neither sex nor rthnic is an ordinal variable) you can do this with

dtable i.(sex rthnic) if MATINH == 95
dtable i.(sex rthnic) if MATINH == 96

In fact, you can even get a single table, with separate columns for the two provinces if you would like:

dtable i.(sex rthnic) if inlist(MATINH, 95, 96), by(MATINH)