I solved it by dividing the time ranges into days and then deleting all observations that didnt occur on Thursdays, now I only have on observation for each week per ID: data want;
set want;
do i=0 to intck('day', from_v, yo_v);
variable_day=intnx('day',from_v,i,'b');
output;
end;
FORMAT variable_day WEEKDATX17.;
run;
data want;
set want;
variable_weekday=weekday(variable_day);
run;
data want;
set want;
weeksfromevent=intck('week',event,variable_day);
run;
data se;
set want;
if variable_weekday NE 5 then delete;
run;
... View more
