clear

capture log close

log using "$pathlog\14_Original 36 Margin of Error Tally_$S_DATE.log",replace

forvalues x=1/12{
forvalues y=48/59{
quietly append using "$pathout36\09_Original 36 Montly Interval Total Exports_`x'_`y'_14 Jul 2020.dta"
}
}

drop if Exports_moe_pe==.

count if Exports_moe_pe<.1

gen moe_100=Exports_moe_pe * 100

sum moe_100,d

sum moe_100 if peak==1,d

rename *,lower

sort month order

format exports_total exports_margin exports_moe_pe moe_100 %20.2fc

collapse (mean) moe_100

export excel moe_100 using "$pathexcelsurr\Exhibit 2-AJL.xlsx",sheetmodify sheet("Original 36")cell(A2),
putexcel set "$pathexcelsurr\Exhibit 2-AJL.xlsx",sheet("Original 36") modify
putexcel A1="Margin as a Percentage", bold

save "$pathout36\14_original 36 moe_$S_DATE.dta",replace

log close