Hey Guys! Just wondering how to calculate the time a client spends. As you can see, there were some gaps that this client was not holding any policy. I would like to take those gap time out of my equation. I am using proc sql;
create table client_lost as
select distinct party_id,
max(end_date) as max_end_date format date9.,
min(START_DATE) as min_start_date format date9.
group by 1
;quit;
data client_lost_2;
set client_lost;
tenure = yrdif(min_start_date,max_end_date,'Actual');
run; Thank you in advance
... View more
