topic Re: reset counter to zero in SAS Programming

reset counter to zero

jenim514 — Mon, 22 Jul 2019 17:58:21 GMT

Hi! I'm trying to count visits with the same date and then reset count to zero when encountering new subject.

This does what I need it to do, but how can I reset to ) when encountering new subject?

proc sort data= lb4; by usubjid lbdat visitx ; run;

data want;

set have;

by subject lbdat;

if first.lbdat then vscount +1;

run;

Thanks!

Re: reset counter to zero

novinosrin — Mon, 22 Jul 2019 18:08:08 GMT

Try

proc sort data= lb4; by usubjid lbdat visitx ; run;

data want;

set have;

by subject lbdat;

if first.subject then vscount=1;

else if first.lbdat then vscount +1;

run;

Re: reset counter to zero

Tom — Mon, 22 Jul 2019 19:14:21 GMT

Use the FIRST.USUBJID variable, just like you are using the FIRST.LBDAT variable.

proc sort data= lb4;
  by usubjid lbdat visitx ; 
run;

data want;
  set lb4;
  by usubjid lbdat;
  if first.usubjid then vscount=0;
  vscount + first.lbdat;
run;