a) What are you doing at parties, then? You seem to do something wrong. b) Go to a party where not everyone drinks, often quite a few persons will drive home so they won't drink. Alternatively, drive other people home. c) You can shift your sleep schedule by going to sleep 15 minutes (or more) later each day. It's a quite simple mechanism, and it works. d) Simple: attend a dancing course! It's a simple yet valuable skill, worth the money and the time. Alternatively, you could watch tutorials on youtube. e) You don't. You don't want to tell me that you're busy with such other things every single evening. If that really is the case, take one of those activities and either let it fall or do it somewhen (I'll just use this word, I don't care whether it's proper English) else.
Now, because that was your true rejection, it's party time for you. Let your friend take you to a party, and have a good time.
I do have fun at some parties, for example pool staff parties with people I've known for years, where all the gossip is relevant to me and I get all the in-jokes. I simply am not extroverted enough to enjoy going to parties where nearly everyone is a stranger, and I have to keep up with my boyfriend's manic introducing-himself-to-people pace. So the real solution is to track down more parties where I'll know the people well, but that reduces the number of people I'll meet, which according to my boyfriend is the point of going to parties.
Your dancing comme...
An exercise:
Name something that you do not do but should/wish you did/are told you ought, or that you do less than is normally recommended. (For instance, "exercise" or "eat vegetables".)
Make an exhaustive list of your sufficient conditions for avoiding this thing. (If you suspect that your list may be non-exhaustive, mention that in your comment.)
Precommit that: If someone comes up with a way to do the thing which doesn't have any of your listed problems, you will at least try it. It counts if you come up with this response yourself upon making your list.
(Based on: Is That Your True Rejection?)
Edit to add: Kindly stick to the spirit of the exercise; if you have no advice in line with the exercise, this is not the place to offer it. Do not drift into confrontational or abusive demands that people adjust their restrictions to suit your cached suggestion, and do not offer unsolicited other-optimizing.
To alleviate crowding, Armok_GoB has created a second thread for this challenge.