topic Re: Count changes in column (lag function) in SAS Programming

Count changes in column (lag function)

PatrykSAS — Wed, 16 Jun 2021 12:13:21 GMT

I would like to count value changes in a column like below:

ID	VALUE	COUNT
1	10	0
1	10	0
1	12	1
1	15	1

In this example ID and VALUE is my data and I want to make count column equal 1 each time the value change in given ID

I heard about lag function which could be helpful but I am not sure how to use it

Re: Count changes in column (lag function)

Ksharp — Wed, 16 Jun 2021 12:21:06 GMT

data have;
input ID	VALUE;
cards;
1	10	
1	10	
1	12	
1	15
;
data want;
 set have;
 by id value notsorted;
 count=first.value;
 if first.id then count=0;
run;

Re: Count changes in column (lag function)

FreelanceReinh — Wed, 16 Jun 2021 12:24:38 GMT

Hi @PatrykSAS,

@PatrykSAS wrote:

I heard about lag function which could be helpful but I am not sure how to use it

Here's how the LAG function could be used:

data want;
set have;
count = value~=lag(value) & id=lag(id);
run;