I saw that you live in a world that is Mountain Dew Code Red-less. Obviously this is a great injustice to you, and I shall help in the best way that I can!
The grocery store I work at still stocks it, so I'm assuming that either your area of NY is made of fail, or just the grocery store that you shop at is made of fail. If it's the latter, you can ask if the people who work at the store can order it for you, since Pepsi still makes the drink. Those who order stock for the store probably thought that the item wasn't selling well at the store.
Now you know way more about the inner workings of a grocery store than you wanted. ^^;
If there's no Code Red in your area at all...move as fast as you can out of there! Go! Go!
(As for my LJ, a lot of what happens on PC/SPPf makes it on there. I just say what's on my mind. =D)