sorted stacked bar graph

[luizaandrade]

Here's some mock code that I created to answer a question on how to create a sorted stacked bar graph at region level starting from a hosehold-level dataset

clear
set obs 20000
gen random = rnormal(0, 2)
gen gender = random >.6
gen order = _n
xtile district = order, nq(6)
drop random
bys district: gen id = district * 1000000 + _n

* Collapse to district level
collapse (count) id, by(district gender)

* One column per gender
reshape wide id, i(district) j(gender)


* Calculate percentages
egen total = rowtotal(id?), m

foreach var of varlist id? {
    replace `var' = (`var'/total) * 100
}

graph bar 	Male Female, ///
			over(district, ///
				sort(1) descending) ///
			stack