assigning same sequence numbers within each group

[michellel]

Hi, I have a question about assigning same sequence numbers within each group of 2 variables. Thanks much for your help! My data looks like below.

ID	count
1	15
1	13
1	13
1	8
2	20
2	20
2	20
2	14
2	14
2	6
2	6

What I want is to create seq_ID as below.

ID	count	seq_id
1	15	1
1	13	2
1	13	2
1	8	3
2	20	1
2	20	1
2	20	1
2	14	2
2	14	2
2	6	3
2	6	3

[LinusH]

By id count;
If first.count then seq_id+1;

[michellel]

Thanks, but this is not working.

1, The count variable was sorted descending

2, I want to assign SAME seq number within each group of same id and same count.

[Astounding · Accepted solution]

Very close.  Try:

data want;

set have;

by id count nosorted;

if first.id then seq_id=1;

else if first.count then seq_id+1;

run;

[michellel]

Thanks Astounding, but it does not work at all. The error message shows

BY variables are not properly sorted on data set. I think that because count variable was sorted descending. I need keep the biggest number of count by the end.

[PGStats]

Very close @Astounding 

by id count descending;

[Astounding]

Good catch.  I might even go a step further:

by id count notsorted;

We really don't have enough insight into the pattern of COUNT and whether it can go both up and down.

[michellel]

Thanks. It works with
by id descending count;

[michellel]

Thanks! It works!

[LinusH]

I think that my code would work if you add DESCENDING.

[michellel]

Thanks! It works now.