Translating data between MySQL and Stata

Michael Johnson () and Phil Schumm ()
Additional contact information
Michael Johnson: Research Computing Group, Department of Health Studies, University of Chicago
Phil Schumm: Research Computing Group, Department of Health Studies, University of Chicago

North American Stata Users' Group Meetings 2004 from Stata Users Group

Abstract: As web-based and other electronic data collection methods become more widely used in research, the opportunities to use statistical software in conjunction with conventional database systems are increasing. Among such systems, MySQL is particularly well suited for research purposes. For example, MySQL's ENUM and SET column types are ideal for storing data collected via the multiple choice questions typically used in social surveys. At the same time, Stata is uniquely suited for working in conjunction with a database; for example, its implementation of characteristics makes it possible to preserve (in a usable form) important information about how the database and front-end application are constructed (e.g., column types and other attributes). In this presentation, we shall describe a Python script we have developed for translating data from MySQL to Stata, and will indicate briefly how we are using it in the development of tools for the collection and management of research data.

Date: 2004-07-15
References: Add references at CitEc
Citations:

Downloads: (external link)
http://repec.org/nasug2004/nasug2004_mystata.pdf handout (application/pdf)

Related works:
This item may be available elsewhere in EconPapers: Search for items with the same title.

Export reference: BibTeX RIS (EndNote, ProCite, RefMan) HTML/Text

Persistent link: https://EconPapers.repec.org/RePEc:boc:asug04:5

Access Statistics for this paper

More papers in North American Stata Users' Group Meetings 2004 from Stata Users Group Contact information at EDIRC.
Bibliographic data for series maintained by Christopher F Baum ().