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')
Good news: We've extended SAS Hackathon registration until Sept. 12, so you still have time to be part of our biggest event yet – our five-year anniversary!
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.
Ready to level-up your skills? Choose your own adventure.