Sequential number question

Reply
New Contributor
Posts: 2

Sequential number question

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

Super User
Posts: 5,255

Re: Sequential number question

Check the value of _n_ in a data step and set your seq accordingly.
What possible business value does this seq no add?
Data never sleeps
Super User
Posts: 17,776

Re: Sequential number question

X = mod(_n_, 3);

New Contributor
Posts: 2

Re: Sequential number question

Thank you Reeza, this is what I need.

 

 

Respected Advisor
Posts: 3,124

Re: Sequential number question

A simple Do-loop;

data want;
do seq=1 to 3;
set have;
output;
end;
run;
Super User
Posts: 9,671

Re: Sequential number question


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;
Ask a Question
Discussion stats
  • 5 replies
  • 293 views
  • 6 likes
  • 5 in conversation