topic Assign sequence numbers that reset for each policy in SAS Programming

Assign sequence numbers that reset for each policy

EinarRoed — Fri, 21 Oct 2016 10:31:36 GMT

I can use the monotonic() function to assign a sequence number for each row. But I want it to reset at each new POLICY_NO.

How can I accomplish this?

RW9 — Fri, 21 Oct 2016 11:22:55 GMT

Use datastep, easier:

data want;
  set have;
  by policy_no;
  retain want;
  if first.policy_no then want=1;
  else sum(want,1);
run;

EinarRoed — Fri, 21 Oct 2016 11:29:56 GMT

Many thanks!

data_null__ — Fri, 21 Oct 2016 12:36:48 GMT

@rw9 Does "else sum(want,1);" work in a data step?

@EinarRoed it may also be written.

if first.policy_no then seq = 0;
seq + 1;

RW9 — Fri, 21 Oct 2016 12:50:29 GMT

Nope, just a typo. Could do:

data want;
  set have;
  by policy_no;
  retain want;
  want=ifn(first.policy_no,1,sum(want,1));
run;

Thats probably easier.