********************************************************** ** Burauel et al. 2019 - Minimum Wage and Working Hours ** ********************************************************** * Main Analysis * ***************** use "${temp}MW_WH_final.dta", clear set dp comma set more off *** Mini Job or Social Security Contributions global mini "& mini==0" global refcat "age "Soziodemographische Variablen" parttime "Beschäftigungs Variablen" educlevel_1 "Bildungsniveau (Referenz: Mittel)" size_1 "Firmengröße" sector_1 "Sektor (Referenz: Prod. Gewerbe)" feligible "Veränderung in" " generat sample_treat= (sample_AZ_1==1 & treat!=0) generat sample_treat_2= (sample_AZ_2==1 & treat!=0) foreach dependent of varlist hours_contr_w hours_act_w { cap drop dif_`dependent' cap drop difrel_`dependent'_100 cap drop diflog_`dependent'_100 cap drop dif_`dependent'_2 cap drop diflog_`dependent'_2_100 cap drop difrel_`dependent'_2_100 gen dif_`dependent' = f.`dependent' - `dependent' gen difrel_`dependent'_100 = (f.`dependent'/`dependent' -1) * 100 gen diflog_`dependent'_100 = ln(f.`dependent'/`dependent') * 100 gen dif_`dependent'_2 = f2.`dependent' - `dependent' gen difrel_`dependent'_2_100 = (f2.`dependent'/`dependent' -1) * 100 gen diflog_`dependent'_2_100 = ln(f2.`dependent'/`dependent') * 100 } *********************** ** Ttests for table 4 * *********************** gen ttesting = 1- under_mw ttest dif_hours_contr_w if sample_treat==1 & inlist(syear,2014) $mini, by(ttesting) ttest diflog_hours_contr_w if sample_treat==1 & inlist(syear,2014) $mini, by(ttesting) ttest dif_hours_act_w if sample_treat==1 & inlist(syear,2014) $mini, by(ttesting) ttest diflog_hours_act_w if sample_treat==1 & inlist(syear,2014) $mini, by(ttesting) gen temp = under_mw if syear==2014 bys pid: egen under_mw_fix = min(temp) replace under_mw_fix = under_mw_fix*d2015 cap gen sample_treat_2_help = 1 if sample_treat_2 == 1 replace sample_treat_2_help = 1 if syear==2015 & sample_treat==1 & l.sample_treat_2_help==1 & l.mini==0 ******************** * 1 Year Analysis * ******************** eststo red_1: reg diflog_hours_contr_w_100 under_mw_2014 under_mw_2013 $controls_year if sample_treat==1 & inlist(syear,2014,2013) $mini , robust cluster(pid) estadd local year "ja" eststo red_2: reg diflog_hours_contr_w_100 under_mw_2014 under_mw_2013 $controls_year $controls_soc_reg if sample_treat==1 & inlist(syear,2014,2013) $mini , robust cluster(pid) estadd local year "ja" estadd local soc "ja" eststo red_3: reg diflog_hours_contr_w_100 under_mw_2014 under_mw_2013 $controls_year $controls_soc_reg $controls_job if sample_treat==1 & inlist(syear,2014,2013)$mini , robust cluster(pid) estadd local year "ja" estadd local soc "ja" estadd local job "ja" eststo red_4: reg diflog_hours_contr_w_100 under_mw_2014 under_mw_2013 $controls_year $controls_soc_reg $controls_job $change_az feligible if sample_treat==1 & inlist(syear,2014,2013) $mini , robust cluster(pid) estadd local year "ja" estadd local soc "ja" estadd local job "ja" eststo red_5: reg diflog_hours_act_w_100 under_mw_2014 under_mw_2013 $controls_year if sample_treat==1 & inlist(syear,2014,2013) $mini , robust cluster(pid) estadd local year "ja" eststo red_6: reg diflog_hours_act_w_100 under_mw_2014 under_mw_2013 $controls_year $controls_soc_reg $controls_job $change_az feligible if sample_treat==1 & inlist(syear,2014,2013) $mini , robust cluster(pid) estadd local year "ja" estadd local soc "ja" estadd local job "ja" estadd local change "ja" *************************************************************************************************************************************************************** * Table 5: DiD regressions for employees subject to social security contributions: effect of minimum wage on the increase in working hours, one-year analysis * *************************************************************************************************************************************************************** #delimit ; esttab red_1 red_2 red_3 red_4 red_5 red_6 using "${export}Table5_regression_1year_ssc.scsv" , fragment noomitted nonumbers nomtitle nogaps nolines nonote stats(line year soc job change N r2_a, fmt(0 0 0 0 0 0 3) labels("Kontrollvariablen" " Jahrdummies" " Sozio" " Job" "Veränderungen" "Beobachtungen" "Adj. R2")) star(* 0.1 ** 0.05 *** 0.01) b(2) se(2) replace label coeflabels(_cons " Konstante" under_mw_2014 "Treatment-Effekt" under_mw_2013 "Placebo-Test") ref($refcat, nolabel); #delimit cr ******************** * 2 Year Analysis * ******************** * Prepare global mini "& mini==0" cap gen sample_treat_2_help = 1 if sample_treat_2 == 1 replace sample_treat_2_help = 1 if syear==2015 & sample_treat==1 & l.sample_treat_2_help==1 & l.mini==0 ******************************************************************************************************************************************************** * Table 6: DiD regressions for employees subject to social security contributions - minimum wage effect on working hours increases - two-year analyses * ******************************************************************************************************************************************************** eststo red2_1: reg diflog_hours_contr_w_100 under_mw_2013 under_mw_2014 i.syear $controls_soc_reg $controls_job $change_az feligible if sample_treat_2==1 & inlist(syear,2013,2014) $mini, robust cluster(pid) estadd local year "ja" estadd local soc "ja" estadd local job "ja" eststo red2_2: reg diflog_hours_contr_w_100 under_mw_2013 under_mw_2014 under_mw_2015 i.syear $controls_soc_reg $controls_job $change_az feligible if sample_treat_2_help==1 & inlist(syear,2013,2014,2015) $mini, robust cluster(pid) estadd local year "ja" estadd local soc "ja" estadd local job "ja" eststo red2_3: reg diflog_hours_contr_w_2_100 under_mw_2012 under_mw_2014 i.syear $controls_soc_reg $controls_job $change_az_2 ffeligible if sample_treat_2==1 & inlist(syear,2012,2014) $mini, robust cluster(pid) estadd local year "ja" estadd local soc "ja" estadd local job "ja" eststo red2_4: reg diflog_hours_act_w_100 under_mw_2013 under_mw_2014 i.syear $controls_soc_reg $controls_job $change_az feligible if sample_treat_2==1 & inlist(syear,2013,2014) $mini, robust cluster(pid) estadd local year "ja" estadd local soc "ja" estadd local job "ja" eststo red2_5: reg diflog_hours_act_w_100 under_mw_2013 under_mw_2014 under_mw_2015 i.syear $controls_soc_reg $controls_job $change_az feligible if sample_treat_2_help==1 & inlist(syear,2013,2014,2015) $mini, robust cluster(pid) estadd local year "ja" estadd local soc "ja" estadd local job "ja" eststo red2_6: reg diflog_hours_act_w_2_100 under_mw_2012 under_mw_2014 i.syear $controls_soc_reg $controls_job $change_az_2 ffeligible if sample_treat_2==1 & inlist(syear,2012,2014) $mini, robust cluster(pid) estadd local year "ja" estadd local soc "ja" estadd local job "ja" #delimit ; esttab red2_1 red2_3 red2_4 red2_6 using "${export}Table6_regression_2year_ssc.scsv" , fragment noomitted nonumbers nomtitle nogaps nolines nonote stats(line year soc job N r2_a, fmt(0 0 0 0 0 3) labels("Kontrollvariablen" " Jahrdummies" " Sozio" " Job" "Beobachtungen" "Adj. R2")) star(* 0.1 ** 0.05 *** 0.01) b(2) se(2) replace label keep(under_mw_2015 under_mw_2014 under_mw_2013 under_mw_2012 _cons) order(under_mw_2015 under_mw_2014 under_mw_2013 under_mw_2012 _cons) coeflabels(_cons " Konstante") ref($refcat, nolabel); #delimit cr ********************************* *** Marginal Employment ********************************* ******************** * 1 Year Analysis * ******************** global mini "& mini==1" ****************************************************************************************************************************************** * Table 7: DiD regressions for workers in marginal employment - minimum wage effect on the increase in working hours - one-year analysis * ****************************************************************************************************************************************** eststo mini_1: reg diflog_hours_contr_w_100 under_mw_2014 under_mw_2013 $controls_year if sample_treat==1 & inlist(syear,2014,2013) $mini , robust cluster(pid) estadd local year "ja" eststo mini_2: reg diflog_hours_contr_w_100 under_mw_2014 under_mw_2013 $controls_year $controls_soc_reg if sample_treat==1 & inlist(syear,2014,2013) $mini , robust cluster(pid) estadd local year "ja" estadd local soc "ja" eststo mini_3: reg diflog_hours_contr_w_100 under_mw_2014 under_mw_2013 $controls_year $controls_soc_reg $controls_job if sample_treat==1 & inlist(syear,2014,2013)$mini , robust cluster(pid) estadd local year "ja" estadd local soc "ja" estadd local job "ja" eststo mini_4: reg diflog_hours_contr_w_100 under_mw_2014 under_mw_2013 $controls_year $controls_soc_reg $controls_job $change_az feligible if sample_treat==1 & inlist(syear,2014,2013) $mini , robust cluster(pid) estadd local year "ja" estadd local soc "ja" estadd local job "ja" eststo mini_5: reg diflog_hours_act_w_100 under_mw_2014 under_mw_2013 $controls_year if sample_treat==1 & inlist(syear,2014,2013) $mini , robust cluster(pid) estadd local year "ja" eststo mini_6: reg diflog_hours_act_w_100 under_mw_2014 under_mw_2013 $controls_year $controls_soc_reg $controls_job $change_az feligible if sample_treat==1 & inlist(syear,2014,2013) $mini , robust cluster(pid) estadd local year "ja" estadd local soc "ja" estadd local job "ja" #delimit ; esttab mini_1 mini_2 mini_3 mini_4 mini_5 mini_6 using "${export}Table7_regression_1year_mini.scsv" , fragment noomitted nonumbers nomtitle nogaps nolines nonote stats(line year soc job N r2_a, fmt(0 0 0 0 0 3) labels("Kontrollvariablen" " Jahrdummies" " Sozio" " Job" "Beobachtungen" "Adj. R2")) star(* 0.1 ** 0.05 *** 0.01) b(2) se(2) replace label keep(under_mw_2014 under_mw_2013 _cons) order(under_mw_2014 under_mw_2013 _cons) coeflabels(_cons " Konstante" under_mw_2014 "Treatment-Effekt" under_mw_2013 "Placebo-Test") ref($refcat, nolabel); #delimit cr ******************** * 2 Year Analysis * ******************** * Prepare global mini "& mini==1" drop sample_treat_2_help cap gen sample_treat_2_help = 1 if sample_treat_2 == 1 replace sample_treat_2_help = 1 if syear==2015 & sample_treat==1 & l.sample_treat_2_help==1 & l.mini==1 ****************************************************************************************************************************************** * Table 11: DiD regression for workers in marginal employment - minimum wage effect on the increase in working hours - two-year analysis * ****************************************************************************************************************************************** eststo mini2_1: reg diflog_hours_contr_w_100 under_mw_2013 under_mw_2014 i.syear $controls_soc_reg $controls_job $change_az feligible if sample_treat_2==1 & inlist(syear,2013,2014) $mini, robust cluster(pid) estadd local year "ja" estadd local soc "ja" estadd local job "ja" eststo mini2_2: reg diflog_hours_contr_w_100 under_mw_2013 under_mw_2014 under_mw_2015 i.syear $controls_soc_reg $controls_job $change_az feligible if sample_treat_2_help==1 & inlist(syear,2013,2014,2015) $mini, robust cluster(pid) estadd local year "ja" estadd local soc "ja" estadd local job "ja" eststo mini2_3: reg diflog_hours_contr_w_2_100 under_mw_2012 under_mw_2014 i.syear $controls_soc_reg $controls_job $change_az_2 ffeligible if sample_treat_2==1 & inlist(syear,2012,2014) $mini, robust cluster(pid) estadd local year "ja" estadd local soc "ja" estadd local job "ja" eststo mini2_4: reg diflog_hours_act_w_100 under_mw_2013 under_mw_2014 i.syear $controls_soc_reg $controls_job $change_az feligible if sample_treat_2==1 & inlist(syear,2013,2014) $mini, robust cluster(pid) estadd local year "ja" estadd local soc "ja" estadd local job "ja" eststo mini2_5: reg diflog_hours_act_w_100 under_mw_2013 under_mw_2014 under_mw_2015 i.syear $controls_soc_reg $controls_job $change_az feligible if sample_treat_2_help==1 & inlist(syear,2013,2014,2015) $mini, robust cluster(pid) estadd local year "ja" estadd local soc "ja" estadd local job "ja" eststo mini2_6: reg diflog_hours_act_w_2_100 under_mw_2012 under_mw_2014 i.syear $controls_soc_reg $controls_job $change_az_2 ffeligible if sample_treat_2==1 & inlist(syear,2012,2014) $mini, robust cluster(pid) estadd local year "ja" estadd local soc "ja" estadd local job "ja" #delimit ; esttab mini2_1 mini2_3 mini2_4 mini2_6 using "${export}Table11_regression_2year_mini.scsv" , fragment noomitted nonumbers nomtitle nogaps nolines nonote stats(line year soc job N r2_a, fmt(0 0 0 0 0 3) labels("Kontrollvariablen" " Jahrdummies" " Sozio" " Job" "Beobachtungen" "Adj. R2")) star(* 0.1 ** 0.05 *** 0.01) b(2) se(2) replace label keep( under_mw_2015 under_mw_2014 under_mw_2013 under_mw_2012 _cons) order( under_mw_2015 under_mw_2014 under_mw_2013 under_mw_2012 _cons) coeflabels(_cons " Konstante") ref($refcat, nolabel); #delimit cr