Following is a response from Senior DHS staff member, Tom Pullum:
Are you aggregating with the "collapse" command in Stata? Sometimes I find it convenient to use "collapse" to calculate a weighted numerator and a weighted denominator , bypassing a weight option, and then doing a division in a collapsed file. The following lines suggest a framework:
gen unwtdn=1
gen wtdn=v005/1000000
collapse (sum) *wtdn, by()
I don't know whether this will apply to your situation. Let us know if you need more detail.