19_sulfonylureas_expR.do

di "$S_TIME"
clear
set more off
tempfile pde_2013 pde_2014 pde2013bc pde2014bc 
use usrds_id srvc_dt gnn using "/dcs01/igm/segevlab/data/usrds2015/claims/pd/pde2013",clear
save `pde_2013',replace
use usrds_id srvc_dt gnn using "/dcs01/igm/segevlab/data/usrds2016/claims/pd/pde2014",clear
save `pde_2014',replace
local year "y=2013/2014"
forvalues `year' {
  capture use `pde_`y'',clear
	if _rc==0 {
		di "processing pde_`y'.dta ..."
gen	urea4=(strpos(gnn,"CHLORPROPAMIDE")!=0)
gen	urea14=(strpos(gnn,"GLIMEPIRIDE")!=0)
gen	urea23=(strpos(gnn,"GLYBURIDE")!=0)      
		gen  urea_rx=( ///	
urea4+	///
urea14+	///
urea23	///
>0)
keep usrds_id srvc_dt urea_rx 
duplicates drop
quietly compress
save `pde`y'bc', replace
	}
}

forvalues `year' {
		 capture append using `pde`y'bc'
}
save 19_sulfonylureas_expR.dta,replace
di "$S_TIME"