topic Enumeration within ID in SAS Procedures

Enumeration within ID

bollibompa — Wed, 18 Jun 2014 21:38:05 GMT

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

Re: Enumeration within ID

Reeza — Wed, 18 Jun 2014 21:57:29 GMT

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

Re: Enumeration within ID

bollibompa — Wed, 18 Jun 2014 22:08:39 GMT

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;

Re: Enumeration within ID

Reeza — Wed, 18 Jun 2014 22:10:25 GMT

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;

Re: Enumeration within ID

Patrick — Wed, 18 Jun 2014 22:24:35 GMT

data want;

set have;

by id;

if first.id then count=1;

else count+1;

run;

Re: Enumeration within ID

bollibompa — Thu, 19 Jun 2014 08:24:05 GMT

Thanks!

Works perfectly!

/Thomas