How to report zero (nonmissing data) in tab

[Luke Schalewski]

I need to report all values in a tabulation which includes legitimate zeros. This is not missing data.

Currently these 0 values are not being reported on the output.

Thank you, L

[Rich Goldstein]

to the best of my knowledge, the official StataCorp commands cannot do this; however, the user-written -fre- can (with the "include(numlist)" option); use -search- to find and download

[John Mullahy]

Also check out -groups- on SSC

ssc describe groups

[Nick Cox]

John Mullahy Thanks for the mention of groups.

The version on SSC is up-to-date, but this command is (please) to be considered as published in the Stata Journal.

I used a name for the command back in 2003 that is manifestly also a common English word. I don't feel as embarrassed about that as perhaps I should, but either way the otherwise unpredictable detail is to look for st0496.

. search st0496, entry

Search of official help files, FAQs, Examples, and Stata Journals

SJ-18-1 st0496_1  . . . . . . . . . . . . . . . . . Software update for groups
        (help groups if installed)  . . . . . . . . . . . . . . . .  N. J. Cox
        Q1/18   SJ 18(1):291
        groups exited with an error message if weights were specified;
        this has been corrected

SJ-17-3 st0496  . . . . .  Speaking Stata: Tables as lists: The groups command
        (help groups if installed)  . . . . . . . . . . . . . . . .  N. J. Cox
        Q3/17   SJ 17(3):760--773
        presents command for listing group frequencies and percents and
        cumulations thereof; for various subsetting and ordering by
        frequencies, percents, and so on; for reordering of columns;
        and for saving tabulated data to new datasets

[Nick Cox]

As a sequel to #3 and #4 note that the scope in groups is only to apply an option fillin that shows cross-combinations of two or more variables that could occur.

The problem reported in #1 is singularly vague. If it concerns a univariate tabulation, groups can’t help with values that might occur but don't, but in addition to fre from SSC, tabcount and countvalues from SSC also might help.

Edit: can’t not can!

[Luke Schalewski]

Thank you all! Extremely helpful.