topic Re: FindW Function a little help in SAS Programming

FindW Function a little help

ManitobaMoose — Thu, 03 May 2018 22:22:59 GMT

Hi,

I cannot figure out why this code is not returning antibiotics = 1 for the comment that has antibiotics in it.

Code below:

-----------------------

Libname Review'/folders/myfolders/Review' ;
Libname Learn'/folders/myfolders/Learn' ;  
Libname myformat'/folders/myfolders/sasuser.v94' ; 
Options fmtsearch=(myformat) ;

Data review.antibiotics ; 


	Set learn.Medical ; 
	If FindW(Comment,'antibiotics','i') then antibiotics = 1 ; 
run ; 

proc print data=learn.medical noobs ; 
run ; 
proc print data=review.antibiotics noobs ; 
run ;

Below are the results

Patno 	Clinic 	VisitDate 	Weight 	HR 	DX 	Comment 	antibiotics
001 	Mayo Clinic 	10/21/2006 	120 	78 	7 	Patient has had a persistent cough for 3 weeks 	.
003 	HMC 	09/01/2006 	166 	58 	8 	Patient placed on beta-blockers on 7/1/2006 	.
002 	Mayo Clinic 	10/01/2006 	210 	68 	9 	Patient has been on antibiotics for 10 days 	/*WHY ANTIBIOTICS = . NOT = 1?*/
004 	HMC 	11/11/2006 	288 	88 	9 	Patient advised to lose some weight 	.
007 	Mayo Clinic 	05/01/2006 	180 	54 	7 	This patient is always under high stress 	.
050 	HMC 	07/06/2006 	199 	60 	123 	Refer this patient to mental health for evaluation

Re: FindW Function a little help

novinosrin — Thu, 03 May 2018 22:32:38 GMT

because 'i' is in place of delimiter specification in your code rather than in place of modifier to ignore case sensitivity

This will work Findw(comment,'antibiotics')

or Findw(k,'antibiotics',' ','i');

Re: FindW Function a little help

ManitobaMoose — Thu, 03 May 2018 22:33:58 GMT

Ok. Thanks. Then, where would I put the 'i' ignore case modifier?

Re: FindW Function a little help

Reeza — Thu, 03 May 2018 22:34:16 GMT

Or:

Findw(comment,'antibiotics', , 'i')

http://documentation.sas.com/?docsetId=lefunctionsref&docsetTarget=p16rdsa30vmm43n1ej4936nwa01t.htm&docsetVersion=9.4&locale=en

FINDW(string, word, character(s), modifier(s) <, start-position>)

modifier

specifies a character constant, variable, or expression in which each non-blank character modifies the action of the FINDW function.

Tip
If you use the modifier argument, then it must be positioned after the character argument.

Re: FindW Function a little help

novinosrin — Thu, 03 May 2018 22:34:25 GMT

If FindW(Comment,'antibiotics',' ','i') then antibiotics = 1 ;

Re: FindW Function a little help

ManitobaMoose — Thu, 03 May 2018 22:40:44 GMT

Hi,

I am still getting the same results with the code below:

Data review.antibiotics ; 
	Set learn.Medical ; 
	If Findw(Comment,'antibiotics', ,'i') then antibiotics = 1 ; /*output review.antibiotics*/ ;  
run ; 

proc print data=learn.medical noobs ; 
run ; 
proc print data=review.antibiotics noobs ; 
run ;

Patno Clinic VisitDate Weight HR DX Comment antibiotics

001	Mayo Clinic	10/21/2006	120	78	7	Patient has had a persistent cough for 3 weeks	.
003	HMC	09/01/2006	166	58	8	Patient placed on beta-blockers on 7/1/2006	.
002	Mayo Clinic	10/01/2006	210	68	9	Patient has been on antibiotics for 10 days	.
004	HMC	11/11/2006	288	88	9	Patient advised to lose some weight	.
007	Mayo Clinic	05/01/2006	180	54	7	This patient is always under high stress	.
050	HMC	07/06/2006	199	60	123	Refer this patient to mental health for evaluation	.

Re: FindW Function a little help

novinosrin — Thu, 03 May 2018 22:41:33 GMT

I gave you the right syntax earlier. here again

If FindW(Comment,'antibiotics',' ','i') then antibiotics = 1 ;

Re: FindW Function a little help

ManitobaMoose — Thu, 03 May 2018 22:43:11 GMT

Thanks!