topic Re: finding a word anywhere in a stirng in SAS Programming

finding a word anywhere in a stirng

lillymaginta1 — Fri, 26 Feb 2021 21:31:15 GMT

data have;
infile cards ;
input ID   drugname ;	 
cards;
001 sodium benzoate 
001 oral sodium 
003 oral potassium 
004 oral oral Sodium 
004 Sodium 
;

I want to retain 1 if the word sodium exist anywhere in the variable "drugname". The word can be written in capital and small letters.

Output

Re: finding a word anywhere in a stirng

novinosrin — Fri, 26 Feb 2021 21:57:28 GMT


data have;
infile cards ;
input ID   drugname & $20.;	 
cards;
001 sodium benzoate 
001 oral sodium 
003 oral potassium 
004 oral oral Sodium 
004 Sodium 
;

data want;
 set have;
 sodium=^^findw(drugname,'sodium',' ','i');
run;

Re: finding a word anywhere in a stirng

Reeza — Fri, 26 Feb 2021 21:58:31 GMT

FINDW()?

if findw(lowcase(drugname), "sodium") > 0;

https://documentation.sas.com/?cdcId=pgmsascdc&cdcVersion=9.4_3.5&docsetId=lefunctionsref&docsetTarget=p16rdsa30vmm43n1ej4936nwa01t.htm&locale=en

@lillymaginta1 wrote:
data have;
infile cards ;
input ID   drugname ;	 
cards;
001 sodium benzoate 
001 oral sodium 
003 oral potassium 
004 oral oral Sodium 
004 Sodium 
;
I want to retain 1 if the word sodium exist anywhere in the variable "drugname". The word can be written in capital and small letters.

Output
ID sodium 
001 1
001 1
003 0
004 1
004 1

Re: finding a word anywhere in a stirng

lillymaginta1 — Fri, 26 Feb 2021 22:08:58 GMT

Thank you both!