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
Simple, if your data is sorted by name:
data want;
set have; by name;
id + first.name;
run;
Simple, if your data is sorted by name:
data want;
set have; by name;
id + first.name;
run;
Thank you!
Don't miss out on SAS Innovate - Register now for the FREE Livestream!
Can't make it to Vegas? No problem! Watch our general sessions LIVE or on-demand starting April 17th. Hear from SAS execs, best-selling author Adam Grant, Hot Ones host Sean Evans, top tech journalist Kara Swisher, AI expert Cassie Kozyrkov, and the mind-blowing dance crew iLuminate! Plus, get access to over 20 breakout sessions.
Learn how use the CAT functions in SAS to join values from multiple variables into a single value.
Find more tutorials on the SAS Users YouTube channel.