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

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

usuario_estudo — Thu, 02 Apr 2020 22:33:01 GMT

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

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

PeterClemmensen — Thu, 02 Apr 2020 20:01:18 GMT

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;

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

usuario_estudo — Thu, 02 Apr 2020 20:45:16 GMT

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.

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

usuario_estudo — Thu, 02 Apr 2020 22:20:26 GMT

@PeterClemmensen