Table-related commands in STATA
Abbreviations of commands
table | (no abbv.) |
---|---|
tabulate | ta tab |
tabstat | (no abbv.) |
summarize | su |
Differences between table, tabulate, tabstat, summarize
one-way | two-way | options | |
---|---|---|---|
table | table v1 create a one-way table of v1 |
table v1 v2 create a two-way table of v1 |
,statistics( ) |
tabulate | tabulate v1 create a one-way table of v1 |
tabulate v1 v2 create a two-way table with v1 |
,chi2 Pearson's chi-squared test; *only for two-way ,summarize(v3) detailed statistics for v3 |
tabstat | tabstat v1 create a one-way table of v1 |
*no two- or multiple-way table | ,statistics( ) ,by(v3) detailed statistics for each of v3 |
summarize | summarize v1 detailed statistics of v1 |
*no two- or multiple-way summary | ,detail |
† row = transverse direction, column = longitudinal direction
Sample data
Suppose we have such a dataset in STATA.
Where,
id | discrete | :Identification number |
---|---|---|
sex | binary | :Male=0, Female=1 |
data1 | continuous | :Results of a certain test |
factorA, B, C | binary | :Negative=0, Positive=1 |
SES | categorical | :Categories of Socio-Economic Status, divided into four |
disease | binary | :Free from a certain disease=0, Having the disease=1 |
One-way
Summary of sex, a binary variable
table | table sex | Both reports frequency but tabulate is more detailed |
---|---|---|
tabulate | tabulate sex | |
tabstat | tabstat sex | Both reports mean but summarize is more detailed |
summarize | summarize sex |
Summary of data1, a continuous variable
table | table data1 | Both reports frequency of each value, which does not make sense |
---|---|---|
tabulate | tabulate data1 | |
tabstat | tabstat data1 | Both reports mean but summarize is more detailed |
summarize | summarize data1 |
Summary of SES, a categorical variable
table | table SES | Both reports frequency but tabulate is more detailed |
---|---|---|
tabulate | tabulate SES | |
tabstat | tabstat SES | Both reports mean but summarize is more detailed |
summarize | summarize SES |
One-way, multiple
table | *Both do not create one-way multiple table | |
---|---|---|
tabulate | ||
tabstat | tabstat sex data1 SES | Reports mean in row (transverse) direction |
summarize | summarize sex data1 SES | Reports more details in column (longitudinal) direction |
Two-way
Summary of factorA based on sex
table | table sex factorA | Both creates the same table but tabulate is better visualized |
---|---|---|
tabulate | tabulate sex factorA | |
tabstat | tabstat factorA, by(sex) | Both reports mean but summarize is more detailed; needs bysort option before the command |
summarize | bysort sex: summarize(factorA) |
Summary of sex based on factorA
table | table factorA sex | Both creates the same table but tabulate is better visualized |
---|---|---|
tabulate | tabulate sex, by(factorA) | |
tabstat | tabstat sex, by(factorA) | Both reports mean but summarize is more detailed; needs bysort option before the command |
summarize | bysort factorA: summarize(sex) |
Summary of data1 based on disease
table | *Both do not create a meaningful table for continuous variable | |
---|---|---|
tabulate | ||
tabstat | tabstat data, by(disease) | Both reports mean but summarize is more detailed; needs bysort option before the command |
summarize | bysort disease: summarize data1 |