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;
Join us for SAS Innovate April 16-19 at the Aria in Las Vegas. Bring the team and save big with our group pricing for a limited time only.
Pre-conference courses and tutorials are filling up fast and are always a sellout. Register today to reserve your seat.
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.