Hi

I have a seemingly easy question. I am examining the rate of a disease by hospital areas. I want to plot the percent of the population with the disease with CI 95 % by hospital. The problem is that I want to sort my graph from the lowest to the highest levels of the disease and I can't figure out how to do this. Hopefully some of you may have input on this.
Code:
* CI 95 %
gen se = (((disease_prop)*(1-disease_prop)/n)^0.5
gen lb = (disease_prop-1.96*se)*100
gen ub = (disease_prop+1.96*se)*100

twoway (rspike lb ub hospital, horizontal xline(1.6)) (scatter hospital disease_percent)
I obtain the following figure which is ok, but I want it sorted from low to high. Moreover, I am working on a secure server so graphs from -ssc- won't help me in this instance.


Array