Enumeration within ID

[bollibompa]

Hi,

I have a list of ID:s (25000 st)  and I now want create a new column next to the ID:S and enumerate each of this ID:n with 1-10. Like this:

ID     number

1     1

1     2

1     3

1     4

1     5

1     6

1     7

1     8

1     9

1     10

2     1

2     2

2     3

2     4

2     5

2     6

2     7

2     8

2     9

2     10

an so one

I hope someone can help me with this!

/Thomas

[Reeza]

SAS FAQ: How can I create an enumeration variable by groups?

[bollibompa]

Thanks

I am not sure that this solves my problem

i would like to write a code to enumerate 1-10 in each ID ( i only have a column with ID:s)

data want;

ser have;

by id;

if first.id then count 1 to 10

run;

[Reeza]

It's easier if you post two data sets, one that you have and one that you want.

data want;

set have;

do number=1 to 10;

     output;

end;

run;

[bollibompa]

Thanks!

Works perfectly!

/Thomas

[Patrick]

data want;

set have;

by id;

if first.id then count=1;

else count+1;

run;