topic Re: How to find a word in SAS Programming

How to find a word

CathyVI — Wed, 28 Jul 2021 19:16:50 GMT

Hi,

How do I find the word "elop' from the work Developmental. I want sas to output anywhere "elop" is within the variable. I thought about using the % in the data statement but got the wrong answer.

e.g

data check;

set test;

if %elop= 'developmental';

run;

Re: How to find a word

jimbarbour — Wed, 28 Jul 2021 20:31:12 GMT

Try

If INDEX(Variable_Name, 'elop');

The following code:

DATA	Have;
	LENGTH	Variable_Name		$32;
	INFILE	DATALINES	MISSOVER;
	INPUT	Variable_Name		$;
DATALINES;
Developmental
Experimental
Tempermental
Elope
Develop
Production
QualityControl
;
RUN;

DATA	Want;
	SET	Have;
	IF	INDEX(LOWCASE(Variable_Name), 'elop');
RUN;

Yields the following results:

Jim

Re: How to find a word

PaigeMiller — Wed, 28 Jul 2021 19:26:43 GMT

You can also use the FIND() function, which has an option that allows you to do the search independent of the case of the letters, if that's something you want to do.

Re: How to find a word

Reeza — Wed, 28 Jul 2021 19:47:08 GMT

FIND() function?