*Monitored PD-RAM Data - Household data I
clear
insheet using "C:\BGD_2004_IAP\Work\IAP-MoniteredPD-RAMData_hhdI.csv"
compress

la var hhno "Household ID No."
la var readno "Reading No."
la var date "Date"
la var time "Time"
la var avepm10 "Average PM-10(mg/m3)"
la var location "Location"
replace location="1" if  location=="kt"
replace location="2" if  location=="lr"
destring location,replace
la def loc 1 "Kitchen" 2 "Living room"
la val location loc

sort hhno
save "C:\BGD_2004_IAP\Data\IAP-MoniteredPD-RAMData_hhdI", replace
*****************************************************************

*Monitored PD-RAM Data - Household data II
clear
insheet using "C:\BGD_2004_IAP\Work\IAP-MoniteredPD-RAMData_hhdII.csv"
compress

la var hhno "Household ID No."
la var readno "Reading No."
la var date "Date"
la var time "Time"
la var avepm10 "Average PM-10(mg/m3)"
la var location "Location"
replace location="1" if  location=="kt"
replace location="2" if  location=="lr"
destring location,replace
la def loc 1 "Kitchen" 2 "Living room"
la val location loc

sort hhno
save "C:\BGD_2004_IAP\Data\IAP-MoniteredPD-RAMData_hhdII", replace
*****************************************************************

**Monitored PD-RAM Data - Ambient Data
clear
insheet using "C:\BGD_2004_IAP\Work\IAP-MoniteredPD-RAMData_ambient.csv"
compress

la var district "District"
la var readno "Reading No."
la var date "Date"
la var time "Time"
la var avepm10 "Average PM-10(mg/m3)"
la var ambient "AMBIENT"
sort district
save "C:\BGD_2004_IAP\Data\IAP-MoniteredPD-RAMData_ambient", replace
*********************************************************************