---------------------------------------------------------------------------------------------------------------------------
      name:  <unnamed>
       log:  C:\Users\320491\Desktop\Final NBER\merge_bartik.log
  log type:  text
 opened on:   9 Jun 2019, 15:17:20

. local path_folder ///
>         "C:\Users\320491\Desktop\Final NBER"

. local metro "\metroData.dta"

. local bartik "\gov_msa.dta"

. 
. cd "`path_folder'"
C:\Users\320491\Desktop\Final NBER

. 
. use "`path_folder'`metro'"

. merge m:1 area_name using "`path_folder'`bartik'"

    Result                           # of obs.
    -----------------------------------------
    not matched                             0
    matched                             2,170  (_merge==3)
    -----------------------------------------

. drop _merge

. save mergedData.dta, replace
file mergedData.dta saved

. 
. import excel ///
>         "`path_folder'\rawData\realGovSpend.xls", ///
>         sheet("semiannual") firstrow clear

. 
. merge 1:m halfDate using mergedData.dta, assert(match using)
(note: variable halfDate was int, now float to accommodate using data's values)
(note: variable year was int, now float to accommodate using data's values)
(note: variable halfyear was byte, now float to accommodate using data's values)

    Result                           # of obs.
    -----------------------------------------
    not matched                             0
    matched                             2,170  (_merge==3)
    -----------------------------------------

. drop _merge

. g rfed=nfed/pfed

. g rdef=ndef/pfed

. xtset area_id halfDate
       panel variable:  area_id (strongly balanced)
        time variable:  halfDate, 48 to 117
                delta:  1 unit

. g drfed=200*(ln(rfed)-ln(l.rfed))
(31 missing values generated)

. g drdef=200*(ln(rdef)-ln(l.rdef))
(31 missing values generated)

. g bartik=drfed*gempshare
(31 missing values generated)

. g bartik_def=drdef*gempshare
(31 missing values generated)

. g bartik_mp=drfed*gemp_mpshare
(31 missing values generated)

. g bartik_defmp=drdef*gemp_mpshare
(31 missing values generated)

. save mergedData.dta, replace
file mergedData.dta saved

. 
. log close
      name:  <unnamed>
       log:  C:\Users\320491\Desktop\Final NBER\merge_bartik.log
  log type:  text
 closed on:   9 Jun 2019, 15:17:22
---------------------------------------------------------------------------------------------------------------------------