Thank you so much @ballardw ! I do have a question about this code after further working with it. I want to add an extra part so that when a column named "Outcome" is "Out Of Time", attempt is 0. I included it here: DATA want;
SET have;
BY ID date time;
RETAIN attempt;
if first.date then attempt=1;
else attempt+1;
if attempt>3 then attempt=3;
IF Outcome ="Out Of Time" then attempt=0;
run; However in some cases it happens that: data Data1;
infile datalines delimiter=',';
input date :ddmmyy10. ID $ time :time8. $ Outcome $40. Attempt;
format date ddmmyy10.;
format time time8.;
datalines;
05/11/2020,1000,8:15:23,Answered,1,
05/11/2020,1000,8:20:10,Out Of Time,0
05/11/2020,1000,8:21:10,Answered,1
05/11/2020,1000,9:05:15,Out Of Time,0
; kinda like the attempt "counter" resets (the third line should be attempt 2, not back to 1). Do you have any idea how I can solve that?
... View more