No, normally you do not need to be sober for your appointment. If this is nevertheless necessary, the doctor or study coordinator will discuss this with you timely.