clear set more off cd "$constructeddirectory\" use alldhsirclean, clear cd "$outdirectory\" keep if polyg~=. keep if latitude~=. keep polyg respeducyears latitude longitude ***Export for mapping in GIS cd "$outdirectory\" outsheet using fig1_polygwithcoords.csv, comma replace ***Export in half degree squares gen latitround=0.5*round(latitude/0.5) gen longitround=0.5*round(longitude/0.5) collapse (mean) polyg respeducyears, by(latitround longitround) outsheet using fig1_rounded.csv, comma replace