Hi all,
Say I have the following observations:
fruit
apple
apple comments
pear
pear comment
banan
I want to delete those have 'comments' and 'comment'.
I wrote code as
data mock; set mock0; run;
data mock;
modify mock;
where fruit contains 'comment' and 'comments';
remove;
run;
But it doesn't remove those with 'comments'. Can I do thses two select at once?
Thanks alot!
where fruit contains 'comment' or fruit contains 'comments';
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;
Would:
data mock; set mock0; where index(fruit,"comment")=0; run;
Not be simpler?
April 27 – 30 | Gaylord Texan | Grapevine, Texas
Walk in ready to learn. Walk out ready to deliver. This is the data and AI conference you can't afford to miss.
Register now and lock in 2025 pricing—just $495!
Still thinking about your presentation idea? The submission deadline has been extended to Friday, Nov. 14, at 11:59 p.m. ET.
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.