Create and Export Tables Using Stata by Mitchell, Michael N.;

Short description:

In Create and Export Tables Using Stata, Michael Mitchell teaches you how to expertly craft custom, publication-quality tables of summary statistics, regression results, and more. Mitchell examined hundreds of published journal articles from many disciplines, searching for commonly used table layouts.

Long description:

In Create and Export Tables Using Stata, Michael Mitchell teaches you how to expertly craft custom, publication-quality tables of summary statistics, regression results, and more. Mitchell examined hundreds of published journal articles from many disciplines, searching for commonly used table layouts. This book breaks down how to create the most popularly used tables by guiding you through examples using Stata’s table, dtable, and etable commands, as well as the collect suite of commands.

This book begins with 24 sample tables, including 6 examples of a Table 1, 8 examples of regression models, 4 examples with Student's t tests, and an example of reporting results from a pretest–posttest design. Each sample table is illustrated step by step, showing you how to create it, customize it, and export it as a Word document. You'll also learn how you can export your table as a PDF or an Excel spreadsheet.

After the quick examples, the book takes a more thorough look at the process of creating a Table 1—a table of descriptive statistics that optionally includes a comparison across groups. This discussion also includes extensive instruction on how to create different types of composite results to include in your table; composite results combine multiple statistics into one cell, such as the mean (SE) or median (IQR).

Next Mitchell focuses on creating tables from regression models, such as multiple regression, multivariate regression, logistic, and multinomial logistic models, and illustrates how to make tables that combine results from several models.

The book ends with a look under the hood, describing what a collection looks like and the steps used by the collect suite of commands for creating a table and filling it in based on the contents of the collection. This information can help you more deeply understand the process of creating tables and help you make more complex tables using Stata.

Create and Export Tables Using Stata is integral to anyone reporting data characteristics or analysis. You will learn how to create tables with the layout, formatting, and style you need. Optimize your workflow by using your styles to automate the creation of any future tables. You will take this book off your shelf over and over again as it quickly becomes your go-to reference for creating tables in Stata.

Table of Contents:

Introduction Read me first Overview of creating tables in Stata Overview of this book Introduction to making and exporting tables Using Unicode characters Useful Stata concepts and commands Twenty-four sample tables Sample 1: Regression with model statistics in the footer Sample 2: Regression with multiple outcomes Sample 3: Regression with multiple groups Sample 4: Regression with multiple models Sample 4b: Regression with multiple models using etable Sample 5: Regression with multiple outcomes and multiple groups Sample 6: Regression with multiple models and multiple groups Sample 7: Regression with multiple outcomes and multiple models Sample 8: Regression with multiple outcomes, multiple models, and multiple groups Sample 9: Student’s t test Sample 10: Student’s t test with Cohen’s d Sample 11: Student’s t test with difference in means Sample 12: Student’s t test with Cohen’s d and difference in means Sample 13: Columns of correlations Sample 14: Column of correlations: Two groups Sample 15: Correlation matrix Sample 16: Correlation matrix with mean and SD in columns Sample 17: Correlation matrix with mean and SD in rows Sample 18: Pretest–posttest randomized controlled trial Sample 19: Table 1 showing all categorical variables, one group Sample 20: Table 1 showing categorical variables by two groups Sample 21: Table 1 showing categorical variables by two groups, with p-values Sample 22: Table 1 showing categorical and continuous variables by two groups Sample 23: Table 1 showing categorical and continuous variables by two groups, with p-values Sample 24: Table 1 showing categorical variables, only "yes" responses Creating tables of descriptive statistics with dtable Exploring how to make tables with dtable Customizing variable labels and factor labels Customizing the numeric format Customizing the string format Selecting the variable statistics Composite results Customizing titles, notes, and display of the sample frequency Grouping results with the by() option Adding row headers Complete examples Creating and exporting regression tables The big picture of creating regression tables Multiple regression models Several models (model 1, model 2, and model 3) Multivariate models Tables with multiple multivariate models Models including factor variables Models including interactions of factor variables Logistic and other nonlinear models Models with multiple equations Customizing regression tables Creating tables: Under the hood Multiple regression Regression tables with multiple models Correlations with summary statistics in the rows Correlations with summary statistics in the columns Appendixes More on exporting tables More on exporting tables to Word More on exporting PDF files More on exporting Excel files Creating tables of estimation results using etable Multiple regression Tables based on multiple estimation commands Multivariate regression Tips for handling common errors Forgetting collect clear Forgetting the modify option Changing the wrong label Ignoring notes or warnings Forgetting to display the label Making reusable code: Nested regression Table of model statistics Table with regression coefficients and model statistics Subject index