Simply calculate week from your data and then use in group by: data a; set a; by id date; retain _dt; if first.id then _dt=date; wk=(date-dt+1)/7; run; proc sql; select count(*) as CNT, calculated CNT / (select count(distinct id) from table A) as response_rate from table A as A, table B as B where A.id = B.id group by wk; quit;
... View more