**open secondary file (IR recode)

use caseid v001 v002 v003 v005 sv005 v024 sdistri v013 v042 v445 v457 v208 v213 v008  b3_01 using "C:\Users\NOUSE\Documents\NFHS_Other\Duplicate\IAIR74FL.DTA", clear
gen hhid=substr(caseid,1,9)
gen hvidx=v003

ren hvidx pid 
ren v001 hv001
ren v002 hv002
ren sdistri shdistri 
rename sv005 shv005 
rename v005 hv005 
ren v024 hv024
sort hhid pid
save C:\Users\NOUSE\Desktop\Merged\secondary.dta, replace 


** Open base file--PR and merge 

use C:\Users\NOUSE\Documents\NFHS_Other\Duplicate\IAPR74FL.DTA
gen pid= hv112
sort hhid pid 
merge m:1 hhid pid using "C:\Users\NOUSE\Desktop\Merged\secondary.dta", keep(master match)
tab _merge


** Generate tabulations on merged dataset (Checked nutritional status across low BMI of mothers)

gen wgt= shv005/1000000
gen lastchild= v008 - b3_01
keep if hc71<9990 & hc70<9990 & hc72<9990 & hv103== 1 & lastchild >=2 & v213 ==0 & hv024== 4
tab hc70 if v445<1850 [iweight=wgt]
tab hc71 if v445<1850 [iweight=wgt]
tab hc72 if v445<1850 [iweight=wgt]