Simply Counter

Bernardita — Fri, 13 May 2016 10:05:58 GMT

Hi,

I simply would like to set a new Var "Counter" thats count to 12 (in the example below to 3) by the ID. I mean within the same ID, it can be hundred of them, I would like to count the rows by 12 (equivalent to months), each time gets to 12 then reset to 1 again until 12, to the end of the rows until ID changes. So this counter repeat itself in the same way for each new ID.

I imagine is simply, my problem is I am only learning!!! Thank you a lot for your help. Bernardita

ID	Counter
A	1
A	2
A	3
A	1
A	2
A	3
A	1
A	2
A	3
A	1
B	1
B	2
B	3
B	1
B	2
B	3
B	1
B	2
B	3
B	1
B	2
C	1
C	2
C	3
C	1
C	2
C	3
C	1
C	2
C	3
C	1
C	2

Re: Simply Counter

RW9 — Fri, 13 May 2016 10:16:31 GMT

Hi,

Yep, pretty simple - I will go by your given example below:

data want;
  set have;
  by id;
  retain counter;
  if first.id or counter > 3 then counter=0;
  else counter=counter+1;
run;

Re: Simply Counter

Bernardita — Fri, 13 May 2016 10:31:48 GMT

This is great!!! Thank you a lot!

topic Simply Counter in SAS Programming

Simply Counter

Re: Simply Counter

Re: Simply Counter