topic Re: Cannot find the word in the string in SAS Programming

Cannot find the word in the string

Ivy — Tue, 17 Apr 2018 21:30:54 GMT

I am trying to find "Paclitaxel" in the string, however I could not find it using index , and , findw , function even I only keep aplphbet and "," . However, I can find "carboplatin" . Any solution ? Thank you very much!

test = compress(lowcase(regimen),'abcdefghijklmnopqrstuvwxyz,','k') ;

if index(test, 'paclitaxel') = 1 then pre_TAXANE = 1 ;

regimen

Afatinib,Carboplatin,Paclitaxel	1	.	.
Afatinib,Carboplatin,Paclitaxel Protein-Bound	1	.	.

Re: Cannot find the word in the string

Reeza — Tue, 17 Apr 2018 21:56:34 GMT

INDEX returns the position, not a 0/1. Therefore your test of =1 will only be true if the word is at the exact beginning. Change your condition to test if it’s >0 instead.

@Ivy wrote:

I am trying to find "Paclitaxel" in the string, however I could not find it using index , and , findw , function even I only keep aplphbet and "," . However, I can find "carboplatin" . Any solution ? Thank you very much!

test = compress(lowcase(regimen),'abcdefghijklmnopqrstuvwxyz,','k') ;

if index(test, 'paclitaxel') = 1 then pre_TAXANE = 1 ;

regimen

Afatinib,Carboplatin,Paclitaxel 1 . .

Afatinib,Carboplatin,Paclitaxel Protein-Bound 1 . .

Re: Cannot find the word in the string

Astounding — Wed, 18 Apr 2018 01:38:56 GMT

There's another good reason that SAS can't find the string ... it isn't there. Character strings in SAS are case-sensitive. So you should be checking:

if index(lowcase(test), 'paclitaxel') then pre_TAXANE = 1 ;

The IF condition will be true for values that are neither 0 nor missing.

***************** EDITED:

@Reeza you're right. My bad. LOWCASE is already built into the logic. Where's that coffee?

Re: Cannot find the word in the string

Reeza — Wed, 18 Apr 2018 01:22:37 GMT

@Astounding doesn't the previous statement lowcase everything?

@Ivy review the modifiers so that you can avoid listing all the alphabet in your list. I think its 'ka' to keep all alphabetic values.

Re: Cannot find the word in the string

Reeza — Wed, 18 Apr 2018 02:00:52 GMT

Coffee? I'm about to go to bed and I'm on the West Coast 😄

Re: Cannot find the word in the string

Ivy — Wed, 18 Apr 2018 14:09:45 GMT

Thank you both very much for the quick response!

It is a bless that your guys here. 🙂

Have a great day !

Re: Cannot find the word in the string

Ivy — Wed, 18 Apr 2018 14:12:14 GMT

I would like to keep all alphabetic and "," , hope this is a way. Thank you again !