asdocx table1 : column percentage

The table1 template provides the convenience of reporting cell, row, or column percentages. The default is to report cell percentages. In this post, I am going to show several examples of reporting column percentages with categorical and binary variables.

1. Column percentages with categorical variables

To compare the results of asdocx’s table1 template with those reported by Stata, let us start with the tabulation of two variables in Stata. Stata’s tabulate command with the option col displays the relative frequency of each cell within its column in a two-way table. Let’s load the nhanes2b data from the web and create a two-way table of diabetes by race. The variable agegrp  is a categorical variable. The tabulate command automatically detects it and reports its categories in the first column of the table.

webuse nhanes2b, clear
tabulate agegrp diabetes ,  col

Here is how the table looks like.

Table1 : column percentages for categorical variable

To create the above table in Table1 format, we need to change the variable order so that the treatment variable is written first.  Also, since we want to report various categories of the variable agegrp, therefore, we need to add the prefix i. to this variable. If we do not add this, asdocx will assume that we prefer to treat this variable as a continuous variable. asdocx command for Table1 template is:

asdocx tabulate diabetes i.agegrp ,  template(table1) col replace

2. Column percentages – binary variables

asdocx offers two options to report a binary variable in the table1 template. (1) report both of its categories. This is the default. asdocx identifies binary variables and report both of its categories. (2) report just the category that has a value of 1. This can be done by using option report(0) or report(1). In both cases, we can choose to report either column, row, or cell percentages.

The variable female is coded as zero and one, and hence is a binary variable. When using report(1) option, asdocx reports the statistics for the category that is coded as one. The col option reports the column percentages, that is the percentage of the female population with and without diabetes. If we want to report both the female and non-female population, we shall just drop the option report().

asdocx tabulate diabetes female ,  template(table1) report(1)  col

Removing option report() from the code, both categories of the binary variable female are reported.

asdocx tabulate diabetes female , template(table1) col