@Bal23 - what code have you run ?
I have preceded a step to read your data and run next code:
data test;
infile datalines dlm=',' truncover;
input id icd $ amoumt date mmddyy10.;
format date ddmmyy10.;
datalines;
2,v234,78.91,01/01/2015
2,v234,96.05,01/01/2015
3,v44,43.74,02/03/2015
3,v44,22.04,02/05/2015
4,e34,52.26,03/06/2015
4,e34,11.27,09/05/2015
5,j23,379.08,04/01/2015
5,j23,217.12,04/02/2015
; run;
proc sort data=test; by id icd date; run;
data want;
set test;
by id;
retain prev_date; drop prev_date;
if first.id then do;
prev_date = date;
output;
end; else
if date - prev_date > 7 then do;
prev_date = date;
output;
end; else delete;
run;
then output contains next lines (date format mmddyy10.):
2 v234 78.91 01/01/2015
3 v44 43.74 02/03/2015
4 e34 52.26 03/06/2015
4 e34 11.27 09/05/2015
5 j23 379.08 04/01/2015
... View more