Hi @hnb_matt_d    Option using formats You can first define a format with the various ranges, and then create a derived variable based on the original one with the format using the PUT() function:   proc format; value daybucket 1- 5= "1 to 5 days" 6-10= "6 to 10 days" 11-15= "11 to 15 days" 16-20= "16 to 20 days" 21-25= "21 to 25 days" 26-30= "26 to 30 days" 30<-high="30+ days" /*exclude 30 in the boundary using "<"*/ ; run; data want; set have; SLA_AGING_CAT = put(SLA_AGING,daybucket.); run; option using IF/THEN statements (less convenient to handle as value are hardcoded)   data want; set have; length SLA_AGING_CAT $ 100; if 1 <= SLA_AGING <= 5 then SLA_AGING_CAT = "1 to 5 days"; else if 6 <= SLA_AGING <= 10 then SLA_AGING_CAT = "6 to 10 days"; else if 11 <= SLA_AGING <= 15 then SLA_AGING_CAT = "11 to 15 days"; else if 16 <= SLA_AGING <= 20 then SLA_AGING_CAT = "16 to 20 days"; else if 21 <= SLA_AGING <= 25 then SLA_AGING_CAT = "21 to 25 days"; else if 26 <= SLA_AGING <= 30 then SLA_AGING_CAT = "26 to 30 days"; else if 30 <SLA_AGING then SLA_AGING_CAT = "30+ days"; run;   You can also automatize the process:   data want; set have; length SLA_AGING_CAT $ 100; do i=0 to 5; if 5*i+1 <= SLA_AGING <= 5*i+5 then SLA_AGING_CAT = catx(" ",5*i+1,"to",5*i+5,"days"); end; if 30 <SLA_AGING then SLA_AGING_CAT = "30+ days"; drop i; run; Best,   ... View more

Hi @raivester  To me, it is quite like the notion of first. and last. internal variables when you have a BY statement. first.variable will be equal to 1 for the first occurence of each group and 0 otherwise. The END statement will be equal to 1 for the very last observation. It can be useful for example if you want to output the very last record only or even in some do loop statements. In your case, END=eof creates an indicator variable named eof which is equal to 1 if it is the last observation -> so the calculation of the macrovariable in the CALL SYMPUT statement will be done only based on this record. Best, ... View more

Hi @pvareschi    Yes I agree with you   Best, ... View more

You're welcome @yuwentaiwan ! ... View more

Hi @r4321  Here is a complimentary approach using PROC MEANS: proc sort data=have out=have_sorted; by ID County Time FocalEvent; run; data have_group; do i=1 until (last.FocalEvent); set have_sorted; by ID County FocalEvent notsorted; if lag(FocalEvent)=1 then group+1; if first.ID then group=1; end; run; data have_group2; set have_group; by ID County group notsorted; if first.County then nobs=1; else nobs+1; run; proc means data=have_group2 noprint; var FocalEvent X1mva X2police nobs; class ID County group; ways 3; output out=have_sum sum= min= max= / autoname; run; data want; set have_sum (keep=ID County FocalEvent_Sum X1mva_Sum X2police_Sum nobs_Min nobs_Max); if nobs_Min ne 1 then Time1 = nobs_Min-1; else Time1 = nobs_Min; rename FocalEvent_Sum = Event X1mva_Sum = X1mva X2police_Sum = X2police nobs_Max = Time2; run; Best, ... View more

Hi @rajd1    Here is a way to achieve this. Could you please clarify the rule to compute delay and reduction? In the following program, I have set reduction and delay to "yes" if there was at least one record equal to "yes", and "none" in other cases. However, I can see that there is a value "Other" for patient 2 at cycle 3. How would you like to handle this case?   Best, proc sql; select distinct ID, DrugName, MaxCycle, MinCycle, countdose, Avgdose, max(FirstDose) as FirstDose, max(LastDose) as LastDose, Delay, Reduction from (select ID, DrugName, max(cycle) as MaxCycle, min(cycle) as MinCycle, count(dose) as countdose, mean(dose) as Avgdose format=8.1, dose*(cycle=calculated MinCycle) as FirstDose, dose*(cycle=calculated MaxCycle) as LastDose, case when sum(lowcase(delay)="yes") > 1 then "yes" else "none" end as Delay, case when sum(lowcase(reduction)="yes") > 1 then "yes" else "none" end as Reduction /*what if "Other" ?*/ from L_line1 group by ID, DrugName) group by ID, DrugName order by ID, DrugName; quit; ... View more