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

[Nimish28]

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

[Kurt_Bremser · Accepted solution]

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;

[Nimish28]

Thank You Kurt , logic worked absolutely fine.