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;