The LAG function creates a FIFO queue that is filled every time the function is called. Calling LAG in a conditional branch means that not all values will make it into the queue.
Restructure your code:
data want;
set have;
by ID;
prev_event_dt = lag(Event_Date);
if first.ID then prev_event_dt = .;
run;
... View more
you should be able to accomplish this with proc sql.
proc sql number;
select id, clinic, adm_dt, max(dis_dt) as dis_dt format=date9., max(diag_cd) as diag_cd
from have
group by id, clinic, adm_dt;
quit;
... View more
Use the BY mechanism:
data have;
input ID Flag;
datalines;
1 0
1 1
1 1
1 1
2 1
2 0
2 0
2 1
2 1
2 0
2 0
3 1
3 1
3 1
3 1
4 0
4 0
4 0
4 1
4 1
;
data want;
set have;
by id flag notsorted;
if first.id then cnt = 0;
if first.flag then cnt + 1;
run;
... View more
