Hi
I have a table A with several variables.
Among all these variables I have one variable called "name". Data are sorted by this variable.
I can have several rows for one value of the column "name".
I would like to distinct them by adding an index column named ID.
An example of my table A
... name ... ... A ... ... B ... ... B ... ... D ... ... E ... ... E ... ... E ... ...
The table I need is like this:
... name ID ... ... A 1 ... ... B 1 ... ... B 2 ... ... D 1 ... ... E 1 ... ... E 2 ... ... E 3 ... ...
Do you know how I can do it?
Thanks
Post test data in the form of a datastep, I am not here to type that in. So this code is just and example:
data want; set have; by name; retain id; id=ifn(first.name1,id+1); run;
Post test data in the form of a datastep, I am not here to type that in. So this code is just and example:
data want; set have; by name; retain id; id=ifn(first.name1,id+1); run;
Thanks for the answer.
Small mistake I correct:
data want; set have; by name; retain id; id=ifn(first.name,1,id+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 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.