topic Re: Fill a variable matching by lines in New SAS User

Fill a variable matching by lines

usuario_estudo — Fri, 03 Apr 2020 13:18:04 GMT

I want to change this code that will fill a variable with the ID corresponding to a minimum age. Because in case we have more than one ID with the same minimum age, I would like to bring the minimum ID (containing the minimum age) for the variable ID_AGE_MIN.

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

Fill a variable matching by lines

usuario_estudo — Fri, 03 Apr 2020 13:10:49 GMT

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

Re: Fill a variable matching by lines

Kurt_Bremser — Fri, 03 Apr 2020 13:41:23 GMT

Please post data in self-contained data steps with datalines, as you were shown in

https://communities.sas.com/t5/New-SAS-User/Create-a-code-in-SAS-with-correspondences-by-line-like-a-vlookup/m-p/637046/highlight/true#M21418

https://communities.sas.com/t5/SAS-Enterprise-Guide/Filter-the-last-rows/m-p/504821/highlight/true#M32249

and

https://communities.sas.com/t5/New-SAS-User/SAS-Filter/m-p/505067/highlight/true#M1089

And please do not double-post.

Re: Fill a variable matching by lines

Astounding — Fri, 03 Apr 2020 15:57:46 GMT

Since we don't have a data set to work with, this is untested code. You'll need to test it to see how close it comes to answering your question.

proc sort data=have;
   by age ID;
run;

data want;
   set have;
   if _n_=1 then id_age_min = id;
   retain id_age_min;
run;