Create a code in SAS with correspondences by line (like a vlookup)

[usuario_estudo]

I would like to create a code that fill in a variable with the value which is the id corresponding to a minimum age. In case you have more than one ID with the same minimum age, Iwould like to bring the smallest ID (containing the smallest age) for the variable ID_AGE_MIN, e.g:

ID AGE ID_MIN_AGE

1	13	3
2	25	3
3	7	3
4	7	3

[PeterClemmensen · Accepted solution]

Perhaps

data have;
input ID AGE;
datalines;
1	13
2	25
3	7 
;

proc sql;
   create table want as
   select *, (select id from have having min(age)=age) as id_min_age
   from have;
quit;

[usuario_estudo]

It's perfect.
I just had one problem:
In case you have more than one ID with the same minimum age. In this case, I would like to bring the smallest ID (containing the smallest age) for the variable ID_AGE_MIN.

[usuario_estudo]

@PeterClemmensen