I think, because of how society views alcohol, it's possible for not drinking to have a negative sociological and emotional effect. For example, someone gets passed up for a promotion because they don't go out to happy hour.
I don't drink, and fortunately I've never worked in an office where that mattered, but my personal choices in consuming drugs should have no professional repercussions unless it negatively impacts my job performance.