data have; infile cards expandtabs truncover; input enrolid (indexdate lastdate service_date) (: mmddyy12.) pay : dollar32.; format indexdate lastdate service_date mmddyy10. pay dollar32.; cards; 1 08/03/2019 12/31/2019 09/05/2019 $10 1 08/03/2019 12/31/2019 11/06/2019 $10 2 01/01/2019 06/30/2019 03/30/2019 $5 2 01/01/2019 06/30/2019 06/23/2019 $5 2 01/01/2019 06/30/2019 06/25/2019 $7 3 01/01/2019 12/31/2019 . . ; data temp; set have; month=1; if not missing(indexdate) and not missing(service_date) then month=ceil(yrdif(indexdate,service_date,'age')*12); run; proc summary data=temp nway; class enrolid month; var pay; output out=temp2(drop=_type_ _freq_) sum=; run; proc summary data=temp2 nway; class enrolid ; var month pay; output out=temp22(drop=_type_ _freq_) max= ; run; data temp23; set temp22; _pay=0; if not missing(pay) then do; do month=1 to month; output; end; end; else do; do month=1 to 48; output; end; end; drop pay; run; data month; do month=1 to 48; output; end; run; proc sql; create table temp3 as select a.*, coalesce(pay,_pay) as pay format=dollar32. from (select * from (select distinct enrolid from temp2),(select * from month)) as a natural left join temp23 natural left join temp2; quit; proc transpose data=temp3 out=want(drop=_:) prefix=month_; by enrolid; var pay; run; ... View more

You'll need to explain how 1111/ d is part of lot 2 given that its claim date is different from b and c. What defines a lot? What define a treatment change? You'll need to explain the derivation of the lot2 end date. You'll need t explain why 2222 isn't finished ... View more

Hello,   Thank you for your reply   I actually posted the same question in a different format for clarity. So, could you please help me figure out the answer to this question?    Link to the post:  https://communities.sas.com/t5/SAS-Programming/How-to-identify-observed-claims-within-a-period-of-time/m-p/800923   ... View more