topic Re: lag calculate in SAS Programming

Test

Emma8 — Mon, 18 Jan 2021 19:19:13 GMT

Re: lag calculate

PGStats — Mon, 18 Jan 2021 18:41:55 GMT

Please explain the value "1_0" in the second observation in more detail.

Re: lag calculate

Emma8 — Mon, 18 Jan 2021 19:19:47 GMT

Re: lag calculate

PGStats — Mon, 18 Jan 2021 18:49:08 GMT

OK, and what is the zero?

Re: lag calculate

PeterClemmensen — Mon, 18 Jan 2021 18:49:20 GMT

I still don’t follow. Please explain further.

Re: lag calculate

PeterClemmensen — Mon, 18 Jan 2021 18:57:16 GMT

Try this

data have;
input ID $ Number;
datalines;
A 1  
A 2  
A 5  
A 19 
A 19 
B 1  
B 3  
;

data want;
   set have;
   by ID;
   if dif(Number) not in (0, 1) then numberoftimes + 1;
   if first.ID then numberoftimes = 0;
run;

Result:

ID  Number  numberoftimes 
A   1       0 
A   2       0 
A   5       1 
A   19      2 
A   19      2 
B   1       0 
B   3       1