09-12-2011 07:15 AM
Its a very basic condition in where clause..
input name $ dept;
where dept ^=1 and name ^= "John";
If I run the above datastep, why is it excluding all rows whose department is 1 or name is John.
It should exclude only if dept is 1 and name is John.
Thanks in advance..
09-12-2011 07:21 AM
It is doing what you asked. If you want it only exclude cases with 1 and John then change to:
where not (dept=1 and name='John');
where dept^=1 or name^='John' ;