Date:         Fri, 31 Aug 2001 07:23:41 -0700
Reply-To:     "Karsten M. Self" <kmself@IX.NETCOM.COM>
Sender:       "SAS(r) Discussion" <SAS-L@LISTSERV.UGA.EDU>
From:         "Karsten M. Self" <kmself@IX.NETCOM.COM>
Subject:      Re: Subsetting/selecting based on a count
In-Reply-To:  <200108311229.f7VCTj049684@listserv.cc.uga.edu>; from
              howard_schreier@ITA.DOC.GOV on Fri, Aug 31,
              2001 at 08:29:44AM -0400
Content-Type: multipart/signed; micalg=pgp-sha1;
protocol="application/pgp-signature";

on Fri, Aug 31, 2001 at 08:29:44AM -0400, Howard Schreier (howard_schreier@ITA.DOC.GOV) wrote:
> Replace the sort with this SQL view definition:
> 
>    proc sql;
>    create view over9 as
>     select * from olshospcost
>      group by hospital, toxin
>      having count(*)>9
>      order by hospital, toxin
>    ;
>    quit;

My read was that the problem needed records for *hospitals* for which
there were N records, not hospital-toxin groupings.  This would require
a correlated subquery.

-- 
Karsten M. Self <kmself@ix.netcom.com>          http://kmself.home.netcom.com/
 What part of "Gestalt" don't you understand?             There is no K5 cabal
  http://gestalt-system.sourceforge.net/               http://www.kuro5hin.org
   Free Dmitry! Boycott Adobe! Repeal the DMCA!    http://www.freesklyarov.org
Geek for Hire                        http://kmself.home.netcom.com/resume.html

[application/pgp-signature]