How assign new order/id to every 5 rows based on order#

[Banana19]

Hi All,

As mentioned in the subject I came across an issue where I need to assign a new order# for every 3 rows. In the below example the data in the NEW ORDER# variable is how I'm expecting.

Name ORDER NEW ORDER#

ABC    1           1

ACC    2           1

ADC    3           1

AEC    4           2

AFC    5           2

AGC    6           2

AHC    7           3

AIC    8           3

AJC    9           3

If the dataset has few rows i can use if condition or something similar but the dataset I have contains 75 millions rows. So i was wondering how to approach this issue?

It would be great if you could help me with this issue.

Thanks in advance,

RD

[novinosrin · Accepted solution]

data have;
input Name $ ORDER;* NEW ORDER#;
cards;
ABC    1           1

ACC    2           1

ADC    3           1

AEC    4           2

AFC    5           2

AGC    6           2

AHC    7           3

AIC    8           3

AJC    9           3
;

data want;
 set have;
 if mod(order, 3) = 1 then new_order + 1;
run;

[Banana19]

It worked when i used the above logic. Thanks a bunch!!