topic Re: Find Text in a Column in SAS Programming

Find Text in a Column

altijani — Thu, 04 Oct 2018 13:01:08 GMT

Greetings Community

I have a very simple/quick question:

I have a column of the data that contains text. Within that text, I need to look if there is a specific text. My data looks like this:

I need the new data to look like this (please note the third observation is shoe and not shoes):

Many thanks

SuryaKiran — Thu, 04 Oct 2018 13:05:27 GMT

use FIND() or INDEX() function if you need to search for a single word. If you have to search for multiple words then use PRXMATCH() function.

something like:

If FIND(item,'shoe','i')>0 then shoes='YES';else shoes='NO';

RW9 — Thu, 04 Oct 2018 13:09:01 GMT

Does case matter, i.e. does shoes=Shoes? If so you might want to upcase.

if index(upcase(item),"SHOES") then shoes="Yes";

I am sure this isn't your full problem though is it? Only one word being checked?

altijani — Thu, 04 Oct 2018 13:36:55 GMT

Right. I just needed a lead for this issue. It is much more than that.

Many thanks though