The table 1 template

---

Introduction

---

The table1 template is an asdocx package that creates “Table 1”, i.e., patient baseline characteristics table commonly found in biomedical research papers. The template can summarize different types of variables such as continuous and categorical variables in a single table.

 

How to Use it

---

The template is free. However, it requires asdocx package, that is currently available at 80% discount for a limited time. The template file is installed automatically when you install asdocx.

After installation of the template, you can use the template as shown below.

Syntax

asdocx tab treatvar basevars, factor(stats) continuous(stats) 
       binary(stats) template(table1) report(cat) cell row col 

 

Syntax Details

---

The syntax starts with the keywords asdocx tab.

The treatvar is the treatment variable, the variable that holds information of the treatment group and placebo groups.

The basevars are all other variables that represent the basic characteristics of the participants.

Option template(table1)  invokes the table1 template.

The option report(cat) allows you to specify a specific category of a categorical variable to report in your output. By default, all categories are included in the report. For example, when working with a binary variable, you can use this option to only report one category (e.g. category 1) and exclude the other (e.g. category 0). It’s worth noting that even though the output may only show one category, all categories are still used in the calculation of relevant statistics.

 

A Simple Example

* Load example dataset
use http://fintechprofessor.com/asdocxAddins/table1.dta, clear

* Make table 1 using the template(table1) option
asdocx tab immigrant bone_arthritis bone_backspin              /// 
       bone_backother bone_neck bone_fibro bone_lupus         /// 
       bone_ehlers bone_deform bone_amp bone_burn nervous_ms  ///
       nervous_seizure nervous_park nervous_stroke           /// 
       other_otherhealth other_anyother ,                   /// 
       template(table1) table_layout(autofit) replace

In the above example, the variable immigrant is the treatvar and all other variables are basevars. After comma, option template(table1) causes asdocx to use the table1 template. The table_layout(autofit) creates a table with tight autofit of contents. The above code should generate the following table.

 

Choosing Statistics

---

Table1 template allows different statistics with categorical / factor variables, continuous variables, and binary variables. The allowed statistics are given below:

 

Option	Details
mean	Mean of the variable
sd	Standard deviation of the variables
ci	95% Confidence interval
n	Counts
N	Counts
frequency	Counts
percentage	Count as Percentage of total *
%	Count as percentage of total
perc	Count as percentage of total
p1	First percentile
p5	5th percentile
*The default is to report cell percentages. Option row or col can be used to report row or column percentages.

 

The statistics presented in the above table can be selectively used with categorical, binary, and continuous variables. The default statistics for each type of variables are given below:
(1) Binary variables : Count (Percentages)
(2) Categorical variables : Count (Percentages)
(3) Continuous variables : Mean (95% confidence interval)

Binary and continuous variables are identified internally by asdocx. To declare a variable as categorical, we need to add i. as a prefix to the variable name. Two statistics can be reported with each type of variables. The first statistic is accompanied by the second one in brackets. Therefore, if we were to report frequency counts and percentages with categorical variable ed, we would write it as i.ed and also add the option cat(N %) or cat(n %) or cat(count perc). Let’s also report mean and confidence interval with continuous variables, therefore, use the option continuous(mean ci).

Example of Choosing Statistics

* Load example dataset
use http://fintechprofessor.com/asdocxAddins/svy.dta, clear

asdocx tab back bskin wskin i.ed, factor(N %) continuous(mean ci) ///
       template(table1) table_layout(autofit) replace

 

Using it with Survey prefix svy:

---

Using template table1 with survey data is not much different than using any other Stata command with the svy: prefix. As a first step, declare the data as survey data and then add the svy: prefix before the tab word. Then all the statistics reported by template1 will have survey weights. See the following example

* Load example dataset
use http://fintechprofessor.com/asdocxAddins/svy.dta, clear

* set the survey parameters
svyset SECLUSTR [pweight=NSALWTCT], strata(SESTRAT)

asdocx svy: tab back bskin wskin i.ed, factor(N %) continuous(mean ci) ///
       template(table1) table_layout(autofit) replace

 

 

More Examples

---

The default is to report cell percentages. If percentages need to be based on column total or row total, then option col or row must be used. The following two examples show this.

Report column percentages

Report row percentages

svy data : factor variables

Treatvar has multiple categories

Order asdocx

---

Yearly license of asdocx is available at $9.99. Its life-time license is available at $49.99. With the asdocx membership, you get :

• Life-time license to use
• All future updates
• All premium templates / plugins.