In addition to other suggestions, check out -groups- from SSC.
There is a write-up at
SJ-3-4 pr0011 . . . . . . . . Speaking Stata: Problems with tables,
Part II
. . . . . . . . . . . . . . . . . . . . . . . . . . . . . . N.
J. Cox
Q4/03 SJ 3(4):420--439 (no
commands)
reviews three user-written commands (tabcount, makematrix,
and groups) as different approaches to tabulation problems
which is accessible to all via
<http://www.stata-journal.com/sjpdf.html?articlenum=pr0011>
Nick
[email protected]
Tomas Lind
I would like to see the value of Z for combinations of A and B (or for
combinations of A, B and C). Missing should be regarded as a category.
I have a large dataset and I generate a new variable Z that depends on
the
values of two other category variables A and B. Is there some easy way
to
let Stata show me which combinations of A, B and Z that i have after
recoding so that I can see that the result is what I want, e.g.
A B Z
1 1 1
1 2 1
1 . 0
2 1 1
etc (other combinations of A and B)
*
* For searches and help try:
* http://www.stata.com/help.cgi?search
* http://www.stata.com/support/statalist/faq
* http://www.ats.ucla.edu/stat/stata/
