I want to be able to have an output where it shows all the goal values. Every day a person had a goal. I want to show the daily goals after my randomization_date variable for each individual person (study_id) for up to 1 year. The randomization_date is a date. goal is numeric. data web.webfinaldataset set web.webfinal day=intnx('day', randomization_date,1); run; proc print web.webfinaldataset; var goal date by study_id; run; ... View more

I have a "start date" and I want to creates a series of daily dates from that date for each individual person in my code. How do I do this?     ... View more

Hi I have a goal variable (numeric): there are multiple goals per person. I have a study_id (character) variable that determines the participant. I want to create a variable that says what the average goal is for each participant.   ... View more

  I'm trying to calculate age based on the date they came for a visit (date0) and their date of birth (dob0) aget=(date0)-(dob0)/365.25;   this calculated age is not working. Do I need to formate anything?   ... View more

I have three different variables ID: 0000 (4 numbers) PID: 0000 (4 numbers) and Study ID BOT000 (three numbers and three characters).   I want to make a new variable called ID_NEW I am trying to merge all three to one variable.   /*DO; IF PID = . THEN PID = 0; END; DO; IF ID = . THEN ID = 0; END; DO; IF Study_ID=. then Study_id=0; End; DO; ID_NEW = ID+PID+STUDY_ID; END;   ... View more