Date:         Wed, 22 Jun 2005 19:37:52 -0700
Reply-To:     thelaker@GMAIL.COM
Sender:       "SAS(r) Discussion" <SAS-L@LISTSERV.UGA.EDU>
From:         thelaker@GMAIL.COM
Organization: http://groups.google.com
Subject:      Re: WHERE clause limits
Comments: To: sas-l@uga.edu
Content-Type: text/plain; charset="iso-8859-1"

> Is there any chance that whatever length limit is operating here applies
> only to the clause that gets echoed back in these NOTEs?  Or are you
> actually getting data in your dset that don't meet your full WHERE
> clause?
>

It's the opposite of your last statement.  I was failing to get
observations in the claims_subset dataset that should have been
included if the full WHERE clause  had been implemented.  When testing
this on real data, I converted this WHERE clause to an IF statement
(changing all the BETWEENs to 'value'<=variable<='value' expressions)
and got all the observations I expected in claims_subset.