2024 Stata Biostatistics and Epidemiology Virtual Symposium · 22 February
|Converting other format files into Stata dataset files
|Kevin Crow, StataCorp
Stata 18 supports importing data in a variety of formats:
import excel reads worksheets from Microsoft Excel (.xls and .xlsx) files.
import delimited reads text files containing data delimited by tabs, commas, or a custom delimiter.
odbc allows you to import data from Open DataBase Connectivity (ODBC) sources into Stata.
jdbc allows you to import data using Java DataBase Connectivity (JDBC) into Stata.
infile (fixed format or free format) allows you to read text files containing fixed-format or free-format data.
import sas reads Version 7 SAS (.sas7bdat) files, and will also read value-label information from a .sas7bcat file.
import sasxport8 reads SAS XPORT Version 8 Transport format files.
import sasxport5 will read SAS XPORT Version 5 Transport format files, and will also read value-label information from a formats.xpf XPORT file.
import spss reads IBM SPSS Statistics (.sav and .zsav) files.
import fred reads Federal Reserve Economic Data; you must have a valid API key obtained from the St. Louis Federal Reserve.
import haver (Windows only) reads Haver Analytics database files.
import dbase reads a version III or version IV dBase (.dbf) file.
spshape2dta translates the .dbf and .shp files of a shapefile into two Stata datasets.
Alternatively, you could purchase a separate data conversion package if none of the above options are applicable to the data you wish to import. Before exploring such an option, check the export options of any other package you may be using. Most packages support exporting to some form of text file which Stata can import or one of the above formats.
Classroom and web training
Teaching with Stata
Statalist: The Stata Forum
Last updated: 16 November 2022
StataCorp LLC (StataCorp) strives to provide our users with exceptional products and services. To do so, we must collect personal information from you. This information is necessary to conduct business with our existing and potential customers. We collect and use this information only where we may legally do so. This policy explains what personal information we collect, how we use it, and what rights you have to that information.
These cookies are essential for our website to function and do not store any personally identifiable information. These cookies cannot be disabled.
Please note: Clearing your browser cookies at any time will undo preferences saved here. The option selected here will apply only to the device you are currently using.