| 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
>
| 
