Statistical Tools

A Stata command that automates building a publication-style descriptives table — mean/SD/min/max for continuous variables and %/n for categorical variables — and writes it directly to Excel via putexcel. Replaces the manual loop-and-matrix workflow typically required to produce a Table 1 with a single command, and supports chaining multiple variable blocks onto the same table.

Installation

net install descrtab, from("https://raw.githubusercontent.com/schwartz-joseph/descrtab/main/") replace

Usage

sysuse auto, clear

descrtab, continuous(price mpg trunk weight length) ///
    categorical(rep78 foreign) ///
    labels(price "Vehicle Price" mpg "Miles per Gallon" rep78 "Repair Record 1978") ///
    order(foreign price rep78 mpg trunk weight length) ///
    using(descriptive_table) sheet(table_1) replace

* Chain another block onto the same table
descrtab, continuous(turn displacement gear_ratio) ///
    using(descriptive_table) sheet(table_1) row(`r(nextrow)')

Full syntax and options (continuous(), categorical(), order(), labels(), using(), sheet(), replace, row(), decform(), intform(), format()) are available via help descrtab once installed.

Citation

Schwartz, J. A. (2026). descrtab (Version 1.0) [Stata command]. https://github.com/schwartz-joseph/descrtab