topic Re: Retain flag for ever delinquency by group in SAS Programming

Retain flag for ever delinquency by group

kevinmo3 — Sun, 26 Sep 2021 18:20:49 GMT

I have amended the following SAS codes for many times but turned out failed, I want to flag those cases with ever delinquency > 30 days by group, could anyone help to produce the desired results. Thank you.

data Patients;
input PatientID MOB DPD @@;
datalines;
1021 1 10 1042 2 32
1053 1 36 1063 3 13
1053 2 17 1021 3 15
1063 1 11 1042 3 18
1021 2 32 1063 4 43
1042 1 60 1021 4 35
1063 2 12 1053 4 45
1053 3 19 1063 5 73
;

proc sort data=Patients;
by PatientID MOB DPD;
run;

data Result;
set Patients;
by PatientID MOB DPD;
retain ever_flag;
if first.PatientID and DPD > 30 then ever_flag = "Y";
else ever_flag = "N";
run;

Original Results (failed)

Desired Results

Re: Retain flag for ever delinquency by group

sbxkoenk — Sun, 26 Sep 2021 19:33:03 GMT

Hello,

I think you want this :

data Patients;
input PatientID MOB DPD @@;
datalines;
1021 1 10 1042 2 32
1053 1 36 1063 3 13
1053 2 17 1021 3 15
1063 1 11 1042 3 18
1021 2 32 1063 4 43
1042 1 60 1021 4 35
1063 2 12 1053 4 45
1053 3 19 1063 5 73
;
run;

proc sort data=Patients;
by PatientID MOB DPD;
run;

data Result;
set Patients;
by PatientID MOB DPD;
retain ever_flag;
if first.PatientID then ever_flag='N';
if DPD > 30 then ever_flag = 'Y';
run;
/* end of program */

Koen

Re: Retain flag for ever delinquency by group

Kurt_Bremser — Sun, 26 Sep 2021 20:25:57 GMT

if first.PatientID and DPD > 30 then ever_flag = "Y";
else ever_flag = "N";

Whenever first.patientid is false, the whole condition becomes false (because of the AND) and the variable is set to "N".

Re: Retain flag for ever delinquency by group

kevinmo3 — Mon, 27 Sep 2021 04:08:04 GMT

Thank you for your assistance. It works.

Re: Retain flag for ever delinquency by group

kevinmo3 — Mon, 27 Sep 2021 04:08:48 GMT

Thank you