These are the gold standard randomized control trials or intervention studies, in which a control group consuming soda is monitored for weight gain over time against a group which stops drinking soda (and all other dietary and lifestyle factors are controlled for).
FORBES: ABC News Attacks Scientist Who Exposed Bias In Obesity Research