topic Re: Sequential number question in SAS Programming

Sequential number question

Lupat — Wed, 17 Aug 2016 13:13:17 GMT

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 — Wed, 17 Aug 2016 13:18:18 GMT

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

Reeza — Wed, 17 Aug 2016 13:19:58 GMT

X = mod(_n_, 3);

Haikuo — Wed, 17 Aug 2016 13:54:51 GMT

A simple Do-loop;

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

Lupat — Wed, 17 Aug 2016 15:32:17 GMT

Thank you Reeza, this is what I need.

Ksharp — Thu, 18 Aug 2016 03:33:24 GMT


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;