new column with customer rank

Ronein — Tue, 20 Nov 2018 07:19:02 GMT

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:

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

Re: new column with customer rank

PeterClemmensen — Tue, 20 Nov 2018 07:26:17 GMT

Do like this

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