topic How to create sequence id for consecutive null values? in SAS Programming

How to create sequence id for consecutive null values?

lpy0521 — Wed, 29 Mar 2023 05:42:46 GMT

Hey there,

how can I make this happening in SAS? I have a columns called points and I would like to create sequential group id for consecutive null values

points	group
1
1
.	1
.	1
1
1
.	2
.	2
1
1
.	3
.	3
.	3

Thanks,

Re: How to create sequence id for consecutive null values?

s_lassen — Wed, 29 Mar 2023 07:22:49 GMT

Something like this?

data want;
  set have;
  if _N_=1 and missing(points) then _group=1;
  if missing(points) and not missing(lag(points)) then _group+1;
  if missing(points) then group=_group;
  drop _group;
run;

Re: How to create sequence id for consecutive null values?

Ksharp — Wed, 29 Mar 2023 11:47:39 GMT

data have;
input points;
cards;
1
1
.
.
1
1
.
.
1
1
.
.
.
;

data want;
 set have;
 by points notsorted;
 if first.points and missing(points) then n+1;
 if missing(points) then group=n;
 drop n;
 run;