A 74% median across nine middle-income countries say global climate change is affecting their area, with droughts or water shortages a top concern.