topic Re: finding word in string uppercase lowercase in SAS Programming

finding word in string uppercase lowercase

lillymaginta1 — Sun, 07 Feb 2021 12:47:33 GMT

Hi Everyone,

I want to retain 1 if the word 'drug' was found in a string, including upper and lower case words.

data have;
infile cards ;
input ID   name ;	 
cards;
001 This is a drug 
001 A drug 
003 Drug
004  None 
004  None
;

Output data

ID   Name              Var
001 This is a drug      1
001 A drug              1
003 Drug                1
004  None               0
004  None               0

Re: finding word in string uppercase lowercase

PaigeMiller — Sun, 07 Feb 2021 12:53:55 GMT

@lillymaginta1 wrote:

Hi Everyone,

I want to retain 1 if the word 'drug' was found in a string, including upper and lower case words.
data have;
infile cards ;
input ID   name ;	 
cards;
001 This is a drug 
001 A drug 
003 Drug
004  None 
004  None
;
Output data
ID   Name              Var
001 This is a drug      1
001 A drug              1
003 Drug                1
004  None               0
004  None               0

Not really sure what "including upper and lower case words" means here, and I don't want to guess. Does your data show an example? Does your data show an opposite example?

Re: finding word in string uppercase lowercase

lillymaginta1 — Sun, 07 Feb 2021 12:57:40 GMT

I meant regardless if the word drug is listed as 'Drug' or 'drug' which is shown in the example above

Re: finding word in string uppercase lowercase

PaigeMiller — Sun, 07 Feb 2021 13:01:27 GMT

You can use the FINDW function, with the 'i' modifier which will ignore the case of the letters. Example: https://documentation.sas.com/?cdcId=pgmsascdc&cdcVersion=9.4_3.5&docsetId=lefunctionsref&docsetTarget=p16rdsa30vmm43n1ej4936nwa01t.htm&locale=en#p0m182cedb5tm4n1n52msdjki57v

Re: finding word in string uppercase lowercase

singhsahab — Sun, 07 Feb 2021 14:15:29 GMT

data have;
infile cards ;
input ID  $3. name  $30. ;
if findw(name,'Drug',' ','i') then var=1;
else var=0;
cards;
001 This is a drug 
001 A drug 
003 Drug
004 None 
004 None
;
run;