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..