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')
Don't miss out on SAS Innovate - Register now for the FREE Livestream!
Can't make it to Vegas? No problem! Watch our general sessions LIVE or on-demand starting April 17th. Hear from SAS execs, best-selling author Adam Grant, Hot Ones host Sean Evans, top tech journalist Kara Swisher, AI expert Cassie Kozyrkov, and the mind-blowing dance crew iLuminate! Plus, get access to over 20 breakout sessions.
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.