DATA Step, Macro, Functions and more

How to find a word in a character string

Reply
Super Contributor
Posts: 272

How to find a word in a character string

[ Edited ]

Dear,

 

I need to find a word in character string and assign values to another variable. I have visit variable. I need to assign values to period variable.Please help. Thank

eg; if visit contains word 'Wk 4' then period=1;

else if visit contains word 'UNSCHEDULED' then period=2.

 

visit

Day 28&29 +/- 3 Wk 4 

Day 27&28 +/- 3 Wk 4

UNSCHEDULED VISIT 1.01

UNSCHEDULED VISIT 2.01

 

Super User
Posts: 6,938

Re: How to a word in a character string

Have a look at the index function.

---------------------------------------------------------------------------------------------
Maxims of Maximally Efficient SAS Programmers
Super User
Posts: 5,082

Re: How to a word in a character string

While INDEX is the right tool, it has to be used wisely.  For example, this would be lazy:

 

if index('KWk 45', 'Wk 4') then period=1;

 

The INDEX function will find "Wk 4" and will set PERIOD to 1.

 

More careful use would append a blank at the beginning and end of both strings:

 

if index(' KWk 45 ', ' Wk 4 ') then period=1;

 

Now INDEX is searching for a 6-character string, and doesn't find it.  Using your VISIT variable:

 

if index(' ' || visit || ' ', ' Wk 4 ') then period=1;

else if index(' ' || visit || ' ', ' UNSCHEDULED ') then period=2;

Ask a Question
Discussion stats
  • 2 replies
  • 192 views
  • 1 like
  • 3 in conversation