help mmat (User-written stata packages: mtab)

Title

mtable1 -- Create matrix and Excel file with key information for Table 1 in a scientific article.

Syntax

mtable1
varlist
[, options
]

varlist indicates name of the exposure variable.

Options
CATvar indicates the varlist of categorical variables.

CONvar indicates the varlist of continuous variables.

MPutexcel indicates the output will be put into an Excel file under the current working folder.

EName indicates the name of the Excel file. The default name is mtable1

CATName indicates the sheet name for the categorical variables in the Excel file. The default name is Categorical

CATList indicates the list of column names in the Excel file for categorical variables

CATRow indicates the starting row-number for the categorical variables in the Excel file. The default name is 5

CONName indicates the sheet name for the continuous variables in the Excel file. The default name is Continuous

CONLlist indicates the list of column names in the Excel file for continuous variables

CONRrow indicates the starting row-number for the continuous variables in the Excel file. The default name is 5

Description

Command mtable1 Create matrix and Excel file with key information for Table 1 in a scientific article.

Options

catvar specify a varlist of categorical variables that should be presented in Table 1 .

convar specify a varlist of continuous variables that should be presented in Table 1.

mputexcel indicates matrix output will be put into Excel file. This option must be combined with the either catlist or conlist or both.

ename indicates the name of the Excel file. The default name is mtable1.xlsx.

catname indicates sheet name for categorical variables. The default name is Categorical.

catlist indicates colname names for categorical variables.

catrow indicates starting row-number for categorical variables.

conname indicates sheet name for continuous variables. The default name is Continuous.

conlist indicates colname names for continuous variables.

conrow indicates starting row-number for continuous variables.

Examples

1. Basic use

.webuse lbw, clear

.mtable1 smoke, cat(race ptl ht ui ftv) con(age lwt) mp catlist(D E F G H) conlist(D E F G H I)

More examples

click on her

Author

Chunsen Wu, the University of Southern Denmark; Odense University Hospital, Denmark

cwu@health.sdu.dk

chunsen.wu@rsyd.dk

Also see