I have broken this down into steps for you. Assuming randomization_date is numerical date values. Untested code for your time series proc sql;
select min(randomization_date),max(randomization_date)
into :startdate, :enddate
from web.goaldata;
quit;
data daily;
date_N="&start_date"d;
do while (date_N<="&end_date"d);
output;
date_N=intnx('day', date_N, 1, 's');
end;
format date_N date9.;
run;
proc sql;
create table studies as
select distinct study_id from web.goaldata;
quit;
proc sql;
create table web.finalgoal as
select * from studies,daily
order by studies;
quit;
... View more