Add only when Flag value changes

NickS2 — Thu, 07 Apr 2022 16:03:20 GMT

Hello All,

I am stuck with this issue where I want to add when there is change in flag value. Example:

ID Flag

1 0

1 1

2 1

2 0

2 1

2 0

3 1

4 0

4 1

Output expected:

ID Flag Cnt

1 0 1

1 1 2

2 1 1

2 0 2

2 1 3

2 0 4

3 1 1

4 0 1

4 1 2

Re: Add only when Flag value changes

Kurt_Bremser — Thu, 07 Apr 2022 16:10:14 GMT

Use the BY mechanism:

data have;
input ID  Flag;
datalines;
1    0
1    1
1    1
1    1
2    1
2    0
2    0
2    1
2    1
2    0
2    0
3    1
3    1
3    1
3    1
4    0
4    0
4    0
4    1
4    1
;

data want;
set have;
by id flag notsorted;
if first.id then cnt = 0;
if first.flag then cnt + 1;
run;

topic Re: Add only when Flag value changes in SAS Programming

Add only when Flag value changes

Re: Add only when Flag value changes