Sequential number question

[Lupat]

Hi,

Can I ask how to create a sequential number in the data set. 

So it looks like this,

ID Seq

A 1

B 2

C 3

D 1

E 2

F 3

G 1

....

Thanks

[LinusH]

Check the value of _n_ in a data step and set your seq accordingly.
What possible business value does this seq no add?

[Reeza]

X = mod(_n_, 3);

[Lupat]

Thank you Reeza, this is what I need.

[Haikuo]

A simple Do-loop;

data want;
do seq=1 to 3;
set have;
output;
end;
run;

[Ksharp]

data have;
input ID $ Seq;
cards;
A 1
B 2
C 3
D 1
E 2
F 3
G 1
;
run;

data want;
 set have;
 if n=3 then n=0;
 n+1;
run;