06-14-2016 05:49 PM
Say I have the following observations:
I want to delete those have 'comments' and 'comment'.
I wrote code as
data mock; set mock0; run;
where fruit contains 'comment' and 'comments';
But it doesn't remove those with 'comments'. Can I do thses two select at once?
06-14-2016 10:15 PM
If you are going to create a new dataset anyway, you might as well filter as you copy:
data mock; set mock0; where not (fruit contains "comment" or fruit contains "comments"); run;