#  Programs 

 



The Stata programs provided here load data publicly available on the web. The programs provide an alternative to sources such as the [St. Louis FRED database](http://research.stlouisfed.org/fred2/) for reading data directly into Stata. I am providing them without any warranty. My publications page contains additional code for replicating specific papers. Some of the programs call a file "paths.do" which must define a global SavePath containing the name of the folder in which the dataset will be saved. Download this [example](/file_url/105) to save the dataset in the current directory.

Bureau of Economic Analysis

- [NIPA main tables](https://dl.dropboxusercontent.com/s/7zmb3w66xismdip/loadnipa.ado?dl=0)
- [NIPA underlying detail](https://dl.dropboxusercontent.com/s/zgvgg6rnb9ji9y6/NIPA-underlying-detail.do)
- [NIPA fixed asset tables](https://dl.dropboxusercontent.com/s/ur3bycrl0tbnt18/NIPA-fixed-asset-tables.do)

Bureau of Labor Statistics

- [QCEW](https://www.dropbox.com/s/nme2psi22uq6vq1/loadqcew.ado?dl=0) (see file heading for syntax instructions)
- [LDB](https://dl.dropboxusercontent.com/s/9r6evd7gidqorsn/ldb-all-data.do) (for windows; sorry, I don't know how to FTP on Macs)

Federal Reserve Board of Governors

- [Financial Accounts of the United States (formerly known as Flow of Funds)](https://dl.dropboxusercontent.com/s/6yeepoj5bo3k6v3/loadfof.ado)

CPS

- [Basic monthly files beginning in 1989](https://dl.dropboxusercontent.com/s/d65d4ca25o7lntc/load_cpsbasic.ado)
- [Basic monthly files before 1989](https://dl.dropboxusercontent.com/s/mrf5k3hnf2ecf4g/load_cpsbasic_pre1989.ado?dl=0)
- [March Supplement beginning in 1989](https://dl.dropboxusercontent.com/s/pxrpw1v0zfmo66p/cps-data.do)
- [Add noncash income to 2004 March supplement](https://dl.dropboxusercontent.com/s/8um1y39korfom96/cps-March-2004.do?dl=0)

Eurostat (Eurostat provides bulk files in .gz format. Requires [gunzipfile](https://dl.dropboxusercontent.com/s/v5f4ob7bl10ffmo/gunzipfile.ado), described below.)

- [Load generic Eurostat file (works for most files)](https://dl.dropboxusercontent.com/s/4p8r8gzg1m6rypi/loadeurostat.ado?dl=0)
- [Daily government ten-year bond yields](https://dl.dropboxusercontent.com/s/0p5cqr1ebwxvm4m/DGS10.ado)

Utility programs

- [Seasonal adjustment program (NOT an official version of x11. See file heading for syntax instructions)](https://dl.dropboxusercontent.com/s/h30qikx986937v2/seasonallyadjust.ado)
- [Program to embed .eps or .pdf figures into a .tex file child file](https://dl.dropboxusercontent.com/s/o37gmvxc2sdluee/TexFigure.ado)
- [Program to embed .tex files (tables or figures) into a compilable document ](https://dl.dropboxusercontent.com/s/wax2rrunssuw8p9/EmbedTex.ado)
- [Stata file of state names, fips codes, and two letter abbreviations](https://dl.dropboxusercontent.com/s/31qf04nnqmg3pi8/State-abbreviation.dta)
- Stata programs to [zip](https://dl.dropboxusercontent.com/s/8bxqrcknhh57k2w/gzipfile.ado) and [unzip](https://dl.dropboxusercontent.com/s/v5f4ob7bl10ffmo/gunzipfile.ado) using command line version of 7zip (syntax mirrors the official stata commands zipfile and unzipfile). First download [7-zip](http://www.7-zip.org/download.html), make a copy of the 7z.exe executable and rename it 7za.exe.

Alternative standard errors

- [Stata implementation of Imbens and Kolesar (Restat 2016) LZ2 cluster robust standard errors with good coverage when the number of clusters is small](https://dl.dropboxusercontent.com/s/2pfpxd8anyl40jp/clustermore.ado?dl=0) ([help file](https://www.dropbox.com/s/tiu2hokx5d3ljx4/clustermore.sthlp?dl=0))
- [Stata implementation of Chodorow-Reich and Wieland (forthcoming) two sample 2sls with overlapping observations](https://dl.dropboxusercontent.com/s/qribn2ltfmwgb57/ts2sls.ado?dl=0) ([help file](https://www.dropbox.com/s/19o77i9mwhac8gw/ts2sls.sthlp?dl=0))