Access Keys:
Skip to content (Access Key - 0)

How can I convert data files between statistical packages like Stata and Excel?

Stata (a common statistical package used in MIT's economics, political science, and other departments) creates .dta files, which are not standard for other statistical software (like SPSS, R, or Excel). Stata can also import tab or comma delimited files, though cleanup is often necessary. Frequently, data sets are only available in other formats and will need to be converted into files that Stata can read.

There are two main options for users looking to convert files.

  • The first, and often easiest, is the commercial software package Stat/Transfer, which is expensive but often the only option for complicated data transfer. For more information, see: http://www.stata.com/products/transfer.html. This software is not standard at MIT but it may be available on machines at MIT in some academic departments and at the Harvard MIT Data Center.

Since conversions can often be tricky, clients with questions may wish to look at the resources in this Wiki article: Where can I obtain support using Stata (statistical package)?.

Note that Stat/Transfer may be the only good way to convert old Stata files into ones readable by newer versions of Stata (which is not backwards compatible with early versions).

Community

Documentation and information provided by the MIT Community


Last Modified:

June 12, 2014

Get Help

Request help
from the Help Desk
Report a security incident
to the Security Team
Labels:
stata stata Delete
c-stata c-stata Delete
spss-review spss-review Delete
Enter labels to add to this page:
Please wait 
Looking for a label? Just start typing.
Feedback
This product/service is:
Easy to use
Average
Difficult to use

This article is:
Helpful
Inaccurate
Obsolete
Adaptavist Theme Builder (4.2.3) Powered by Atlassian Confluence 3.5.13, the Enterprise Wiki