Most middle-aged women do not give up sex as they age, especially if sex is important to them, according to a new study.