Hi there,

I'm working on a project where I'm looking at the effect of conflict on a child's birthweight. I have an estimate for conflict during the child's month of birth as well as for many months before and after.

Here is a slice of my data.

Code:
clear
input double Incident float(Incident_1 Incident_2 Incident_3 Incident_4 Incident_5 Incident_lead7 Incident_lead8 Incident_lead9 Incident_lead10 Incident_lead11 Incident_lead12 birthweight)
0 0 0 0 0 0 0 0 0 0 0 0 3000
0 0 0 0 0 0 0 0 0 0 0 0 2000
0 0 0 0 0 0 0 0 0 0 0 0 3300
0 0 0 0 0 0 0 0 0 0 0 0 3500
0 0 0 0 0 0 0 0 0 0 0 0 3000
0 0 0 0 0 0 0 0 0 0 0 0 3000
0 0 0 0 0 0 0 0 0 0 0 0 3000
0 0 0 0 0 0 0 0 0 0 0 0 3000
0 0 0 0 0 0 0 0 0 0 0 0 3500
0 0 0 0 0 0 0 0 0 0 0 0 3500
0 0 0 0 0 0 0 0 0 0 0 0 3000
0 0 0 0 0 0 0 0 0 0 0 0 3000
0 0 0 0 0 0 0 0 0 0 0 0 2750
0 0 0 0 0 0 0 0 0 0 0 0 2750
0 0 0 0 0 0 0 0 0 0 0 0 3000
0 0 0 0 0 0 0 0 0 0 0 0 3000
0 0 0 0 0 0 0 0 0 0 0 0 1750
0 0 0 0 0 0 0 0 0 0 0 0 3000
0 0 0 0 0 0 0 0 0 0 0 0 2750
0 0 0 0 0 0 0 0 0 0 0 0 2700
0 0 0 0 0 0 0 0 0 0 0 0 3000
0 0 0 0 0 0 0 0 0 0 0 0 3500
0 0 0 0 0 0 0 0 0 0 0 0 2000
0 0 0 0 0 0 0 0 0 0 0 0 3000
0 0 0 0 0 0 0 0 0 0 0 0 2500
0 0 0 0 0 0 0 0 0 0 0 0 3500
0 0 0 0 0 0 0 0 0 0 0 0 3000
0 0 0 0 0 0 0 0 0 0 0 0 3000
0 0 0 0 0 0 0 0 0 0 0 0 3750
0 0 0 0 0 0 0 0 0 0 0 0 3500
0 0 0 0 0 0 0 0 0 0 0 0 4250
0 0 0 0 0 0 0 0 0 0 0 0 2500
0 0 0 0 0 0 0 0 0 0 0 0 2700
0 0 0 0 0 0 0 0 0 0 0 0 2250
0 0 0 0 0 0 0 0 0 0 0 0 2750
0 0 0 0 0 0 0 0 0 0 0 0 2000
0 0 0 0 0 0 0 0 0 0 0 0 2500
0 0 0 0 0 0 0 0 0 0 0 0 3000
0 0 0 0 0 0 0 0 0 0 0 0 3000
0 0 0 0 0 0 0 0 0 0 0 0 3000
0 0 0 0 0 0 0 0 0 0 0 0 3500
0 0 0 0 0 0 0 0 0 0 0 0 3200
0 0 0 0 0 0 0 0 0 0 0 0 5000
0 0 0 0 0 0 0 0 0 0 0 0 2000
0 0 0 0 0 0 0 0 0 0 0 0 3000
0 0 0 0 0 0 0 0 0 0 0 0 2500
0 0 0 0 0 0 0 0 0 0 0 0 3000
0 0 0 0 0 0 0 0 0 0 0 0 3000
0 0 0 0 0 0 0 0 0 0 0 0 3500
0 0 0 0 0 0 0 0 0 0 0 0 2000
0 0 0 0 0 0 0 0 0 0 0 0 3000
0 0 0 0 0 0 0 0 0 0 0 0 4000
0 0 0 0 0 0 0 0 0 0 0 0 5000
0 0 0 0 0 0 0 0 0 0 0 0 3500
0 0 0 0 0 0 0 0 0 0 0 0 3000
0 0 0 0 0 0 0 0 0 0 0 0 3500
0 0 0 0 0 0 0 0 0 0 0 0 3000
0 0 0 0 0 0 0 0 0 0 0 0 3000
0 0 0 0 0 0 0 0 0 0 0 0 2500
0 0 0 0 0 0 0 0 0 0 0 0 3500
0 0 0 0 0 0 0 0 0 0 0 0 3000
0 0 0 0 0 0 0 0 0 0 0 0 1750
0 0 0 0 0 0 0 0 0 0 0 0 3000
0 0 0 0 0 0 0 0 0 0 0 0 3000
0 0 0 0 0 0 0 0 0 0 0 0 2500
0 0 0 0 0 0 0 0 0 0 0 0 2500
0 0 0 0 0 0 0 0 0 0 0 0 4500
0 0 0 0 0 0 0 0 0 0 0 0 4000
0 0 0 0 0 0 0 0 0 0 0 0 2225
0 0 0 0 0 0 0 0 0 0 0 0 3000
0 0 0 0 0 0 0 0 0 0 0 0 3500
0 0 0 0 0 0 0 0 0 0 0 0 3500
0 0 0 0 0 0 0 0 0 0 0 0 3000
0 0 0 0 0 0 0 0 0 0 0 0 3500
0 0 0 0 0 0 0 0 0 0 0 0 2500
0 0 0 0 0 0 0 0 0 0 0 0 3800
0 0 0 0 0 0 0 0 0 0 0 0 3000
0 0 0 0 0 0 0 0 0 0 0 0 3000
0 0 0 0 0 0 0 0 0 0 0 0 1900
0 0 0 0 0 0 0 0 0 0 0 0 2500
0 0 0 0 0 0 0 0 0 0 0 0 3500
0 0 0 0 0 0 0 0 0 0 0 0 3000
0 0 0 0 0 0 0 0 0 0 0 0 3000
0 0 0 0 0 0 0 0 0 0 0 0 3500
0 0 0 0 0 0 0 0 0 0 0 0 3500
0 0 0 0 0 0 0 0 0 0 0 0 3300
0 0 0 0 0 0 0 0 0 0 0 0 3300
0 0 0 0 0 0 0 0 0 0 0 0 2070
0 0 0 0 0 0 0 0 0 0 0 0 3000
0 0 0 0 0 0 0 0 0 0 0 0 3000
0 0 0 0 0 0 0 0 0 0 0 0 3000
0 0 0 0 0 0 0 0 0 0 0 0 3000
0 0 0 0 0 0 0 0 0 0 0 0 2000
0 0 0 0 0 0 0 0 0 0 0 0 3000
0 0 0 0 0 0 0 0 0 0 0 0 3000
0 0 0 0 0 0 0 0 0 0 0 0 2500
0 0 0 0 0 0 0 0 0 0 0 0 3000
0 0 0 0 0 0 0 0 0 0 0 0 3000
0 0 0 0 0 0 0 0 0 0 0 0 3000
0 0 0 0 0 0 0 0 0 0 0 0 2225
end
I want to regress birthweight on conflict for the month of birth, as well as months before and after. Then I want to produce a plot of the coefficients where my Y-axis is the Beta_hat on conflict and my X-axis is the number of months from birth.

Code:
rename Incident_lead12 conflict

reg birthweight conflict
eststo reg_1

drop conflict
rename Incident_lead11 conflict

reg birthweight conflict
eststo reg_2

drop conflict
rename Incident_lead10 conflict

reg birthweight conflict
eststo reg_3

drop conflict
rename Incident_lead9 conflict

reg birthweight conflict
eststo reg_4

drop conflict
rename Incident_lead8 conflict

reg birthweight conflict
eststo reg_5

drop conflict
rename Incident_lead7 conflict

reg birthweight conflict
eststo reg_6

coefplot (reg_1) (reg_2) (reg_3) (reg_4) (reg_5) (reg_6), vertical title("Event Study") ytitle("Estimate") keep(conflict) nokey legend(off) yline(0) ///
                           xlabel (1 "-18" 2 "-17" 3 "-16" 4 "-15" 5 "-16" 6"-17") xtitle("Months from Birth")
Array


This is a portion of the regressions I'll be running but its enough to illustrate my problem. The coefficients are not being plotted in line with the X axis. If someone could help me with that I would be very grateful!