topic Re: Count cumulative by groups in SAS Programming

Count cumulative by groups

ywon111 — Mon, 17 Apr 2023 23:34:35 GMT

Hi, I have below table that I want to count by Obj and if same date then this can be ignored as same count. If date is zero then want is zero.

Thanks in advance

Kurt_Bremser — Tue, 18 Apr 2023 05:31:48 GMT

data want;
set have;
by obj;
if first.obj then want = 0;
if dates ne . and (obj ne lag(obj) or dates ne lag(dates)) then want + 1;
run;

s_lassen — Tue, 18 Apr 2023 07:44:40 GMT

Assuming that your data is sorted by OBJ and DATE (meaning that missing dates come first) this should do it

data want;
  set have;
  by obj date;
  if first.obj then count=not missing(date);
  else count+first.date;
run;