find exact match in a text string

[jenim514]

Hi!  

I have string values with

Cycle 1 Day 1

Cycle 1 Day 15

Cycle 2 Day 1

.

.

Cycle 23 Day 1

Cycle 23 Day 15

I want to output 'Day 1' observations regardless of cycle.  Using index, is outputting a Day 15's as well since it 'contains' Day 1.

data want
set have
if index(visit, "Day 1") then do;
cycle = input(scan(VISIT, 2), 3.);

end;
if cycle ne ''  ;
run;

Help is appreciated!

[Reeza · Accepted solution]

Why not just grab the number at the end using SCAN(string, 4) and check if that equals 1?

[jenim514]

I was totally overthinking it! Thank you!

[ballardw]

Or try

if findw(visit, "Day 1") then ...