Remember that the prohibition era did not expel alcohol, just the purchase of it, according to the 18th amendment to the U.S. Constitution.
But to answer the question, it increased crime (Al Capone), reduced worker absence, lower alcohol consumption
However, after a bit, prohibition was repealed with the 21st amendment.
Hope this helped :)