single or multiple spaces followed by keyword

[SASPhile]

How to select only those records that have the word "AND" with single or multiple spaces before and after it.

Standarad

Standarad And Poor

Standarad and   Poor

So would like to select the only :

Standarad And Poor

Standarad and   Poor

[Astounding]

if index(upcase(varname), ' AND ');

You would have to handle separately any cases where And is the first word, and so does not appear with a leading space.

You could use WHERE instead of IF (especially if you are subsetting as part of a SAS procedure).

[Jagadishkatam]

data have;
input text:&$200.;
if prxmatch('m/\sand\s*/i',strip(text));
cards;
Standarad
Standarad And Poor
Standarad and   Poor
;

[r_behata]

the 'i' modifier in the findw function ignores the case.

data want;
	set have;
	if findw(varname,'and',' ','i');
run;