topic Re: Extracting part of a title in SAS Programming

Extracting part of a title

Walternate — Fri, 01 Feb 2013 17:02:29 GMT

Hello,

I have a variable listing book titles and I'd like to identify which titles have the word "End" in them. The word can be at different positions in the title so I'm not sure which command to use.

Thanks!

Re: Extracting part of a title

DBailey — Fri, 01 Feb 2013 17:05:45 GMT

index(title,'END')

Re: Extracting part of a title

data_null__ — Fri, 01 Feb 2013 17:20:38 GMT

The OP mentioned word end not string. I would think indexW.

Re: Extracting part of a title

Astounding — Fri, 01 Feb 2013 17:36:30 GMT

Building upon what has already been suggested:

search_result = indexW(upcase(title), 'END');

SEARCH_RESULT will be 0 when END is not found, and > 0 when it is found.

Good luck.

Re: Extracting part of a title

data_null__ — Fri, 01 Feb 2013 17:49:41 GMT

OR maybe FINDW with option to ignore case. So may choices. :smileyshocked:

Re: Extracting part of a title

AncaTilea — Fri, 01 Feb 2013 18:09:26 GMT

I think :

found = (prxmatch('m/end/i', title) > 0); * the 'i' allows for both lower or upper case, it tells SAS that the match is case insensitive;

Good luck!

Anca.

Re: Extracting part of a title

Data_Detective_23219 — Mon, 04 Feb 2013 15:36:10 GMT

indexW would be my choice coupled with the upcase function in order to remedy any upper/lower case variations of the word end.

Re: Extracting part of a title

VD — Mon, 04 Feb 2013 16:50:35 GMT

Assuming that your title variable is BookTitleVar:

proc sql;

create table want as

select BookTitleVar

from have

where upcase(BookTitleVar) like '%END%';

quit;