topic create unique id for different patients-multiple rows per each in SAS Programming

create unique id for different patients-multiple rows per each

lillymaginta — Fri, 07 Oct 2016 22:21:30 GMT

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

Re: create unique id for different patients-multiple rows per each

PGStats — Fri, 07 Oct 2016 22:34:59 GMT

Simple, if your data is sorted by name:

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

Re: create unique id for different patients-multiple rows per each

lillymaginta — Wed, 12 Oct 2016 14:36:49 GMT

Thank you!