A massive snowstorm has wreaked havoc in the north-eastern US and left seven people dead in upstate New York.