Data sample1;
Set sample;
By id;
If first.id then rn = 1;
Else rn + 1;
Run;
Proc SQL;
Create table sample2 as
Select ID, Entry, Discharge, Event, los, rn,
Case
When Event = 'discharge1' then 'Stop'
When Event = 'death' then 'Stop'
When Discharge >= "30sep2015"d then 'Stop'
Else '.'
End as Include
From sample1;
Quit;
Proc SQL;
Create table sample3 as
Select ID, rn
From sample2
Where Include = 'Stop';
Quit;
Proc SQL;
Create table sample4 as
Select sample2.ID, sum(sample2.los) as cum_los
From sample2
Left join sample3 on sample2.ID = sample3.ID
Where sample2.rn <= sample3.rn or sample3.ID is null
Group by sample2.ID;
Quit;
... View more