st: FW: tabout incorrect frequencies

From: Richard Fox
Sent: 18 October 2011 14:29
To: 'statalist@hsphsun2.harvard.edu'
Subject: tabout incorrect frequencies
Hi,
Whilst using tabout to create latex tables I noticed that some of the frequencies are incorrect.
So a situation where I have such an issue is where a variable has all missing values.
A small amount of background here; so in the example below I'm tabulating how aetiologies were identified, by bloods, biopsy or other. These are all bools, so either 0 or 1 (or missing).
There are actually 5 patients that have blood = yes, and both AetHepC_biopsy and AetHepC_oth are completely missing. The tabulated frequencies correctly report the 5 bloods = yes but also report that there are 5 biopsies= yes and 5 others= yes when in fact they're both missing.
Apologies for the long-winded explanation - has anyone else had this issue?
tabout AetHepC AetHepC_blood AetHepC_biopsy AetHepC_oth using temp.tex, rep ///
c(freq col) f(0 0) clab(N %) ///
style(tex) bt font(bold) wide(22) ///
topstr(9cm) botstr(Temp data) one
Best regards,
Richard
Richard Fox
Biostatistician
Cancer Research UK Clinical Trials Unit
School of Cancer Sciences
University of Birmingham
Vincent Drive
Edgbaston
Birmingham
B15 2TT
Tel: 0121 4143410
Fax: 0121 4143700
email: FoxRP@bham.ac.uk
DISCLAIMER: This e-mail is for the exclusive use of the intended recipient(s) only. If an addressing or transmission error has misdirected this e-mail and you are not the intended recipient(s), please accept our apologies. Please do not disclose, copy or distribute information in this e-mail or take any action in reliance on its contents: to do so is strictly prohibited and may be unlawful. Please inform us that this message has gone astray by replying to it before deleting it. Thank you for your co-operation.
*
* 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/