Check out -groups- and -tabcount- from SSC.
There was a write-up in
Speaking Stata: Problems with tables, Part II.
Stata Journal 3(4): 420--439 (2003)
You need, however, to be very careful with terminology
in this connection: when you refer to missing values here you
mean values that are not present, not at all the
same thing!
Nick
[email protected]
Eddy
> I have a variable, myx, which has 5 possible values. I have used
> -bysort group: myx- to tabulate myx by the group indicator. It works
> well, except that, because some of the groups do not have all the 5
> possible values of myx, tables of these groups contain less than
> 5 rows.
>
> For my particular need, I wish that for these groups Stata would
> still tabulate all the 5 values of myx, putting 0 as the Freq. and
> Percent for the values of myx that are missing in the particular
> group.
>
> Is there an easy way to do this? I looked at the help of -tabulate-,
> -tabi-, -tab1-, and -tab2-, but did not find solutions.
*
* For searches and help try:
* http://www.stata.com/support/faqs/res/findit.html
* http://www.stata.com/support/statalist/faq
* http://www.ats.ucla.edu/stat/stata/