Help using Base SAS procedures

Enumeration within ID

Reply
Contributor
Posts: 73

Enumeration within ID

Hi,

I have a list of ID:s (25000 st)  and I now want create a new column next to the IDSmiley Frustrated 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

Super User
Posts: 19,851

Re: Enumeration within ID

Posted in reply to bollibompa
Contributor
Posts: 73

Re: Enumeration within ID

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;


Super User
Posts: 19,851

Re: Enumeration within ID

Posted in reply to bollibompa

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;

Contributor
Posts: 73

Re: Enumeration within ID

Thanks!

Works perfectly!

/Thomas

Respected Advisor
Posts: 4,173

Re: Enumeration within ID

Posted in reply to bollibompa

data want;

set have;

by id;

if first.id then count=1;

else count+1;

run;

Ask a Question
Discussion stats
  • 5 replies
  • 295 views
  • 0 likes
  • 3 in conversation