new column with customer rank

[Ronein]

Hello

For the following data set I  want to add a new column.

For first customer ID it will get value 1

For second customer ID it will get value 2

So the new column will get values: 

1

1

1

2

2

2

Data tbl1;
input ID x;
cards;
123456 2
123456 4
123456 6
212321 8
212321 10
212321 12
;
run;

[PeterClemmensen · Accepted solution]

Do like this

data want;
   set tbl1;
   by ID notsorted;
   if first.ID then rank+1;
run;