create unique id for different patients-multiple rows per each

[lillymaginta]

Hi I have the following dataset were each patients have multiple rows for the same patient. I am trying to change names to an id. 

Name    date drug
jack    01/01/2009 a
jack    02/02/2010  b
jack   03/03/2001   c
bob   01/01/2001   d
bob   02/02 /2002   e

I want the following output 

Name    date drug    id 
jack    01/01/2009 a  1 
jack    02/02/2010  b  1
jack   03/03/2001   c   1
bob   02/02 /2002   e  2
bob   01/01/2001    d  2

[PGStats · Accepted solution]

Simple, if your data is sorted by name:

data want;
set have; by name;
id + first.name;
run;

[lillymaginta]

Thank you!