DATA Step, Macro, Functions and more

Simply Counter

Accepted Solution Solved
Reply
Occasional Contributor
Posts: 11
Accepted Solution

Simply Counter

 

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

 

IDCounter
A1
A2
A3
A1
A2
A3
A1
A2
A3
A1
B1
B2
B3
B1
B2
B3
B1
B2
B3
B1
B2
C1
C2
C3
C1
C2
C3
C1
C2
C3
C1
C2

Accepted Solutions
Solution
‎05-13-2016 06:31 AM
Super User
Super User
Posts: 7,401

Re: Simply Counter

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;

View solution in original post


All Replies
Solution
‎05-13-2016 06:31 AM
Super User
Super User
Posts: 7,401

Re: Simply Counter

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;
Occasional Contributor
Posts: 11

Re: Simply Counter

This is great!!! Thank you a lot!

☑ This topic is SOLVED.

Need further help from the community? Please ask a new question.

Discussion stats
  • 2 replies
  • 179 views
  • 2 likes
  • 2 in conversation