Hi,
Its a very basic condition in where clause..
data person;
input name $ dept;
datalines;
John 1
Mary 1
Matt 2
Rob 3
Mary 3
;
run;
data filter;
set person;
where dept ^=1 and name ^= "John";
run;
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..
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');
or
where dept^=1 or name^='John' ;
Or, if you have a hard time understanding double negatives, just use something like:
where not(dept=1 and name='John')
Join us for SAS Innovate April 16-19 at the Aria in Las Vegas. Bring the team and save big with our group pricing for a limited time only.
Pre-conference courses and tutorials are filling up fast and are always a sellout. Register today to reserve your seat.
Learn how use the CAT functions in SAS to join values from multiple variables into a single value.
Find more tutorials on the SAS Users YouTube channel.