help cctable-------------------------------------------------------------------------------

cctable.ado, for Stata version 8.0 or higher Sept 2007Tools for EpidemiologyUnivariate case control analysis for each exposure, results are summarized into one table. One row, one exposure. Result file contains: ordering number of exposure(id), name of variable (exposure), total number of cases, number of exposed cases, percentage of exposed among cases, number of controls, number of exposed controls, percentage of exposed among controls, odds ratio, 95%CI interval, 95% p-value.

Collaborative work by Gilles Desve and Peter Makary. Special thanks to Alain Moren. In case of any question please contact us: g.desve@epiconcept.fr peter.makary@ktl.fi (Opinions, notices are welcome as well!)

Summary table for case-control study

Syntax

cctable[varlist] [if] [in] [,options]

optionsDescription ------------------------------------------------------------------------- MainexactCalculate 2-sided exact p-value (default is chi square test p-value)nosortResults are displayed in the same order of variables in the command lineorSort result by odds ratio, descending orderpeSort result by percentage of exposed among cases, descending orderpvalueSort result by pvalues, ascending order (default)replaceReplace the current dataset with the cctable resultnoabbreviateDisplay full exposure name (default fisrt 12 chars) -------------------------------------------------------------------------bymay not be used withcctable.

Description

cctablecalculate number and percentage of exposed among cases and controls, odds ratio, 95%CI interval, 95% p-value for each variable ofvarlist. The result table could be sorted by odds ratio, p-value or percentage of exposed.Result could be copied with "copy table" in order to be pasted in Excel. Alternatively, the

replaceoption store results as a new dataset. Then, results can be exported or saved in a new dataset.

Options+------+ ----+ Main +-------------------------------------------------------------

exactrequests Fisher's exact p be calculated rather than the chi-squared and its significance level. Specifying exact is recommended whenever samples are small. A conservative rule of thumb for 2x2 tables is to specify exact when the least-frequent cell contains fewer than 1,000 cases. When the least-frequent cell contains 1,000 cases or more, there will be no appreciable difference between the exact significance level and the significance level based on the chi-squared, but the exact significance level will take considerably longer to calculate. Note that exact does not affect whether exact confidence intervals are calculated.

nosortSpecifies that the order of the exposures will be the same in the result table as it was in the command.

orResults will be sorted by odds ratio in descending order.

peResults will be sorted by percentage of exposed among cases in descending order.

pvalueResults will be sorted by p-value in ascending order. If no other sorting option is used, results will be sorted by ascending p-value as default.

replaceSpecifies that the result table willreplacethe original dataset in the memory and it will appear in the browser window. It means that the original dataset will be deleted from the memory.preservethenrestoremay be used to get back the original dataset, or upload it again with theusecommand.replaceis used to create dataset from the result table (e.g. to save it), or to solve "copy table" incompatibilities in certain cases.

noabbreviateDisplays full exposure name (default 12 first chars).

As with theRemarkscccommand, variables used withcctablemust be coded as 0/1. Sorting results only available in version 9 For detailed information contact g.desve@epiconcept.fr or peter.makary@ktl.fi

Examples

. cctable ill mousse tiramisu beer sex agegrpThe result table is sorted by ascending p-value

. cctable ill mousse tiramisu beer, orThe result table is sorted by descending odds ratio

Also seecstable,csinter,cc.Manual:

Online: