Hi,
I have been tasked to assign the same numbers (not increments) for duplicate records. Here is an example of what I want to accomplish:
ID Code Number
A 1
B 2
C 3
D 4
D 4
E 5
F 6
G 7
G 7
G 7
Thanks!
hi ..., if data are sorted by IDCODE ...
data new;
set old;
by idcode;
number+first.idcode;
run;
ps take a look at ... http://www.sascommunity.org/wiki/Tips:Between_and_Within_Group_Counters
Thanks dude,
I didn't want to write 20+ if-then statements for each letter of the alphabet lol...
ScottyB_73 wrote:
Thanks dude,
I didn't want to write 20+ if-then statements for each letter of the alphabet lol...
In your sample data , there is only one variable idcode .
The same with Mike, Assuming you have sorted dataset by idcode.
data want;
set have;
if idcode ne lag(idcode) then number+1;
run;
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 the difference between classical and Bayesian statistical approaches and see a few PROC examples to perform Bayesian analysis in this video.
Find more tutorials on the SAS Users YouTube channel.