Registre SAS

alexandraIFCT — Fri, 02 Dec 2022 23:03:53 GMT

Hello,
I'm trying to auto-create the last column. I tried with a retain but didn't succeed. could you help me please?
Thanks in advance
alexandra

Re: Registre SAS

s_lassen — Sat, 03 Dec 2022 06:11:22 GMT

Please post your example data as a data step, e.g. like this:

data have;
  length Patient_id $1;
  informat Treatment_date mmddyy10.; 
  format Treatment_date mmddyy10.;  
  input Patient_id Treatment_date;
cards;
A 1/1/2020  
A 1/1/2020  
A 5/1/2022  
B 1/12/2021  
C 1/25/2020  
C 6/1t/2021  
D 12/31/2021  
D 12/31/2021  
D 5/25/2022  
D 7/10/2022  
D 7/10/2022  
D 10/4/2022  
;run;

I guess (you did not describe the result you wanted, just showed the example) the calculation you want can be done like this (data must be sorted, as is your example data):

data want;
  set have; 
  by Patient_id Treatment_date;
  if first.Patient_id then
    Treatment_no=1;
  else if first.Treatment_date then
    Treatment_no+1;
run;

All pretty simple. The statement "Treatment_no+1" is a "sum" statement, and is equivalent to

Treatment_no=sum(Treatment_no,1);
retain Treatment_no;

topic Re: Registre SAS in SAS Programming

Registre SAS

Re: Registre SAS