DOI: 10.7910/dvn/i4lnju
title: Replication Data for: Moral Hazard and the Energy Efficiency Gap: Theory and Evidence

description: Code and data to produce final results and summary statistics using Stata 15.1. There are four code files (and a master do file to call them in sequence) and three data sets to produce the results in the paper. All data are included in a single .ZIP file (uncompressed files exceeded upload limits).
description: INSTRUCTIONS

Download GiraudetHoudeMaher2018.zip and unzip. The unzipped file contains the following folder structure (assuming files unzipped to a "C:drive"):

 C:\GiraudetHoudeMaher2018
 .do files are at the level of the main directory
 

 C:\GiraudetHoudeMaher2018\data
 data are located in a "data" folder (homeusage.dta, homes.dta, retrofits.dta)
 source files (with readme file for each) are in separate folders


DO FILES
(master.do, 1_retrofit.do, 2_homeusage.do, tables3&4.do, tables1&2.do)

 master.do: runs the other four .do files in sequence to reproduce the data (using 
 source data inputs) and reproduces results and summary statistics presented in 
 tables 1, 2, 3, & 4 of the paper. 

 1_retrofit.do : builds a dataset of participants in each of GRU's retrofit rebate 
 programs. This file needs should be run first. 

 2_homeuseage.do : creates two data sets: homes.dta and homeusage.dta - with the 
 monthly billing data from 2000-2015 for all GRU customers. This .do file aggregates 
 the raw data files, merges with retrofit.dta (GRU rebate program participants) using 
 addresses, and creates variables used for the empirical analysis. 

 tables1&2.do : reproduces summary statistics in tables 1 & table 2. (Note: code 
 outputs table 2 in two parts: one spreadsheet with cols 1-6 & col 10 , and a second 
 spreadsheet with cols 7-9.)

 tables3&4.do : reproduces results presented in tables 3 and table 4 .


.DTA (DATA) FILES
(homesusage.dta, homes.dta, retrofits.dta)

 homesusage.dta : This data reproduces all results using tables3&4.do and 
 tables1&2.do. The data can be reproduced from source files using homeusage.do. 
 Data includes monthly electiricty and natural gas billing data from 2000 - 2015 for all 
 GRU customers in Gainesville, FL. 

 homes.dta : An intermediate dataset used to link merge homeusage.dta and 
 retrofits.dta.

 retrofits.dta: Data with information on all program participants for all GRU rebate 
 programs. The data can be reproduced from source files using homeusage.do. 

SOURCE DATA

 homes (folder) : folder contains source data on house characteristics downloaded 
 from gainsvillegreen.com. These are aggregated into a single .DTA stata file called 
 homes.dta by running "homeusage.do" 

 homusage (folder): folder contains source data on monthly electricity and natural gas 
 energy consumption downloaded from www.gainsvillegreen.com. These are 
 aggregated into a single .DTA stata file called homesusage.dta by running 
 "homeusage.do" 

 retrofits (folder) : folder contains separate spreadsheets containing information on all 
 of GRU's conservation incentive programs. There are combined into a single .DTA 
 file called retrofits.dta by runing "retrofit.do" 

NOTES

Data is in a .ZIP file (uncompressed files exceeded upload limits). 

Use of another directory will require changing the "$root" global macro at the begining of .do files to match the new directory filepath (default directory is "C:\GiraudetHoudeMaher2018")

Table 2 uses the tabout .ado package (the command -ssc install tabout- is included in the code, however, this requires an internet connection in install).