Identify records with min

lizzy28 — Sun, 10 May 2015 23:17:32 GMT

Hi all,

I've got decent help here and am still looking for more.

This time I am trying to find records with minimum values. My sample data looks like below:

My target data is

That is, I want to find records with minimum value of days_gap for each personid. Does anyone know a way to do it?

Thanks a lot as always!

Lizi

Re: Identify records with min

stat_sas — Sun, 10 May 2015 23:43:30 GMT

proc sql;

create table want as

select * from have

group by personid

having days_gap=min(days_gap);

quit;