topic Re: Extracting a substring that has an inconsistent starting position in SAS Programming

Extracting a substring that has an inconsistent starting position

seahill — Mon, 29 Nov 2021 20:40:56 GMT

I have a variable that contains alphanumeric strings of different lengths. While there's some variation among all of the entries, the word "submarine" is always present. The position of "submarine" can vary.

I want you extract "submarine" and everything that follows it. How do I do that given the variable position of "submarine"?

Re: Extracting a substring that has an inconsistent starting position

Tom — Mon, 29 Nov 2021 20:47:01 GMT

Use the INDEX() function. Or possible FIND(), INDEXW() or FINDW().

want = substrn(index(have,'submarine'));

Re: Extracting a substring that has an inconsistent starting position

ChrisNZ — Tue, 30 Nov 2021 07:09:32 GMT

or use prxchange

NEWSTR = prxchange('s/(submarine.*)/\1/, 1, STR);