Date:         Mon, 7 Nov 2005 14:33:10 -0500
Reply-To:     Sigurd Hermansen <HERMANS1@WESTAT.COM>
Sender:       "SAS(r) Discussion" <SAS-L@LISTSERV.UGA.EDU>
From:         Sigurd Hermansen <HERMANS1@WESTAT.COM>
Subject:      Re: sql 'where' clauses not working!@#$%
Content-Type: text/plain; charset="US-ASCII"

Dick:
Are you updating records using a SAS SQL pass-thru query, or using SAS
LIBNAME access to Oracle?

I've heard of problems with SAS WHERE statements, particularly in Data
steps, in one of the releases of SAS V8. That got fixed a couple of
years ago or more: see

http://ftp.sas.com/techsup/download/hotfix/82_win_sbcs.html#ba
(Search for 'WHERE')

Why SAS 8.2 at this late date?
Sig
-----Original Message-----
From: owner-sas-l@listserv.uga.edu [mailto:owner-sas-l@listserv.uga.edu]
On Behalf Of dick
Sent: Monday, November 07, 2005 11:58 AM
To: sas-l@uga.edu
Subject: sql 'where' clauses not working!@#$%


Hello,

Two months ago I received a new laptop at work Win XP - with SAS 8.2.
This is when my problems started:

Sometimes portions of my where statements in proc sql are ignored and
disastrous things are happpening. Just this morning SAS update 14000+
records in Oracle - on a job that I've used for a few years without
problem - where it only should have been about 850. I was able to undo
the update, but this is downright dangerous!

Has anyone else experienced this and if so, what was your remedy?