The most common types of prescription drugs to cause night sweats in men over 50 include: 1  Antipyretics (Celebrex, for example) 2  Anxiety (Anxiolytic medications: Xanax, for example) 3  Diabetes. Depression.  Erectile dysfunction (Cialis or 1  Viagra) Nitrates (most commonly for chest  pain)