topic Re: find exact match in a text string in SAS Programming

find exact match in a text string

jenim514 — Tue, 30 Jan 2018 21:08:17 GMT

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 — Tue, 30 Jan 2018 21:08:26 GMT

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

jenim514 — Tue, 30 Jan 2018 21:12:40 GMT

I was totally overthinking it! Thank you!

ballardw — Tue, 30 Jan 2018 23:45:23 GMT

Or try

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