Archive

Posts Tagged ‘tables’

Just released from Stata Press: An Introduction to Stata for Health Researchers, Fifth Edition

Stata Press is pleased to announce the release of An Introduction to Stata for Health Researchers, Fifth Edition, by Svend Juul and Morten Frydenberg. This book debuted at #1 on Kindle’s new release list for Probability & Statistics and debuted on the top ten list on Kindle’s new release list for Mathematics. Read more…

Customizable tables in Stata 17, part 4: Table of statistical tests

In my last post, I showed you how to use the new and improved table command with the statistic() option to create a classic table 1. In this post, I want to show you how to use the command() option to create a table of statistical tests. Our goal is to create the table in the Microsoft Word document below. Read more…

Export tabulation results to Excel—Update

It’s summer time, which means we have interns working at StataCorp again. Our newest intern, Chris Hassell, was tasked with updating my community-contributed command tab2xl with most of the suggestions that blog readers left in the comments. Chris updated tab2xl and wrote tab2docx, which writes a tabulation table to a Word file using the putdocx command.
Read more…

Retaining an Excel cell’s format when using putexcel

In a previous blog entry, I talked about the new Stata 13 command putexcel and how we could use putexcel with a Stata command’s stored results to create tables in an Excel file.

After the entry was posted, a few users pointed out two features they wanted added to putexcel:

  1. Retain a cell’s format after writing numeric data to it.
  2. Allow putexcel to format a cell.

In Stata 13.1, we added the new option keepcellformat to putexcel. This option retains a cell’s format after writing numeric data to it. keepcellformat is useful for people who want to automate the updating of a report or paper. Read more…

Categories: Programming Tags: , , , , ,

Export tables to Excel

Update 07 June 2018: See Export tabulation results to Excel—Update for new features that have been added since this original blog.

There is a new command in Stata 13, putexcel, that allows you to easily export matrices, expressions, and stored results to an Excel file. Combining putexcel with a Stata command’s stored results allows you to create the table displayed in your Stata Results window in an Excel file. Read more…

Categories: Programming Tags: , , , ,