How to assign a unique ID number to each group of identical values in a column?

koya — Tue, 03 Mar 2015 22:50:35 GMT

?my data:

accname

=======

abc

xyz

abc

def

xyz

def

desired output:

accname uniqid

======= =====

abc 1

xyz 2

abc 1

def 3

xyz 1

def 3

Re: How to assign a unique ID number to each group of identical values in a column?

mohamed_zaki — Wed, 04 Mar 2015 01:18:30 GMT

proc sort data=have;

by accname;

run;

data want;

set have;

by accname;

retain order 0;

if first.accname then order=order+1;

run;