I am trying to find a word with .Character string 'with' in the title and is zero if there is no first occurrence of 'with' in the text.Moreover, I dont want WITH or WitH type of words. I am using the following code. I am not getting proper output. It is not giving me the numeric value of with in the title or text. Hope to hear suggestions.
data want;
set have;
length firstwith 4;
firstwith = (findw(lowcase(string),'with')>0);
run;
You're close.
Your function appears correct, but you don't need the > 0 portion. That turns it into a true/false calculation rather than returning the index.
You also shouldn't apply lowcase if your test is case sensitive. And since you're searching for a word, use FINDW()
Index_with = findw(string, 'with');
Join us for SAS Innovate April 16-19 at the Aria in Las Vegas. Bring the team and save big with our group pricing for a limited time only.
Pre-conference courses and tutorials are filling up fast and are always a sellout. Register today to reserve your seat.
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.