I don’t know if there’s good data on the sugary drinks tax yet, but tobacco taxes have absolutely greatly reduced tobacco use. www.ncbi.nlm.nih.gov/pmc/articles/PMC3228562/From the intro of that article:
Tobacco taxation, passed on to consumers in the form of higher cigarette prices, has been recognized as one of the most effective population-based strategies for decreasing smoking and its adverse health consequences