Date:         Mon, 12 Nov 2007 22:24:05 -0600
Reply-To:     Yu Zhang <zhangyu05@GMAIL.COM>
Sender:       "SAS(r) Discussion" <SAS-L@LISTSERV.UGA.EDU>
From:         Yu Zhang <zhangyu05@GMAIL.COM>
Subject:      Re: Screens
In-Reply-To:  <OFC4882CE8.CB02E61B-ON85257391.007525D2-85257391.007538CB@hgsi.com>
Content-Type: text/plain; charset=ISO-8859-1

proc sql;
select id, screen from
one group by id
having sum(screen<=0.1)>=1;
quit;

HTH

Yu


> Dear All:
> My data set is as folows
>
> ID        Screen
> A           0.05
> A           0.15
> A           0.02
> B           0.2
> B           0.3
> C           0.4
> C           0.02
> C           0.5
> If even one of the individual records of an ID have a screen value that is
> less than or equal to 0.1 then then all the records of that ID should be
> selected.  So all the values of ID A should be selected and all the values
> of ID C should be selected.  All the values of ID B should be dropped.
> Any suggestions?
> Thanx.
>            Randy
>