topic Re: Proc SQL Group By Question in SAS Procedures

Proc SQL Group By Question

deleted_user — Fri, 27 Aug 2010 17:07:45 GMT

Hello All,
I hope you can help me on this. In my dataset I have siblings and their addresses. I am trying to group all siblings by address, so I know all the siblings who reside at an address. Now in this group I only want to pick the youngest sibling and get that information. I am trying to do this in EG, I have the dataset sorted by mailing address, but I would like to know is there a way where I can get the youngest sibling in the group. (something like select top 1)
Here is my dataset

Address name age
111 street1 child1 5
111 street1 child2 10

In this group I only want to output info for
child1

Thanks for any help
Shri

Re: Proc SQL Group By Question

RickM — Fri, 27 Aug 2010 17:14:22 GMT

I think this would be much easier in a data step after you sort by address and age and then use first.address with by group processing to find the youngest.

Good luck!

Re: Proc SQL Group By Question

art297 — Fri, 27 Aug 2010 19:14:22 GMT

Shri,

What do you want to do if the youngest are twins? If you don't confront any twins, or want multiple records in such a case, you could try something like:

proc sql noprint;
create table want as
select *
from have
group by Address
having age eq min(age)
;
quit;

HTH,
Art