Date: Wed, 22 Jun 2005 19:37:52 -0700
Sender: "SAS(r) Discussion" <SAS-L@LISTSERV.UGA.EDU>
Subject: Re: WHERE clause limits
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
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.