topic How to find the product churn on a month on month basis in SAS Enterprise Guide

How to find the product churn on a month on month basis

Nimish28 — Thu, 20 May 2021 15:29:02 GMT

Hi All

I have a dataset like this
Id pcp_id date
1 2222 202001
1 2222 202002
1 3333 202003
1 3333 202004
1 3333 202005

So the output should be like
Whenever the pcp_id for a id changes is a churn and should be in the output, so in the above case the pcp changes at 202003 so it has to be the output.

Need your help to build a logic for this.

Thanks in advance

Re: How to find the product churn on a month on month basis

Kurt_Bremser — Thu, 20 May 2021 15:35:12 GMT

Use BY group processing and the LAG function in a subsetting IF in a data step:

data want;
set have;
by id;
if not first.id and lag(pcp_id) ne pcp_id;
run;

Re: How to find the product churn on a month on month basis

Nimish28 — Thu, 20 May 2021 16:50:37 GMT

Thank You Kurt , logic worked absolutely fine.