topic Re: single or multiple spaces followed by keyword in New SAS User

single or multiple spaces followed by keyword

SASPhile — Fri, 14 Dec 2018 17:32:00 GMT

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 — Fri, 14 Dec 2018 17:52:44 GMT

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 — Fri, 14 Dec 2018 17:53:35 GMT

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

r_behata — Fri, 14 Dec 2018 18:04:58 GMT

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

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