New York City mayor Michael Bloomberg has voiced his support for a proposed tax on sugar sweetened beverages in the US state.