www.elsblog.org - Bringing Data and Methods to Our Legal Madness

17 February 2014

Interfacing Excel and Stata

In a bow to its market, the folks at Stata continue to tinker with Excel interfaces. Stata v.13 introduces a new command, putexcel, which enables Stata users to create tables in an Excel file (described here). A recent post to the Stata Blog describes a few new options, available in Stata 13.1. Specifically, Stata 13.1 includes a new option, keepcellformat. The option retains a cell’s format after writing numeric data to it. The keepcellformat option will interest people who want to automate the updating of a report or paper.