topic Re: FINDW FUNCTION ISNT'T CAPTURING ALL THE OBSERVATIONS in SAS Programming

FINDW FUNCTION ISNT'T CAPTURING ALL THE OBSERVATIONS

bn820 — Thu, 01 Jun 2023 22:44:50 GMT

The FINDW function is returning smaller count of observations compared to the dataset. e.g) The code returns a freq of 5 for adherence but the actual count is 8 in the dataset. Below is my code:

IF FINDW (upcase(SocialEmotinalStress),upcase('Unstable Housing'))>0 THEN BS_Housing=1; ELSE BS_Housing=0;
IF FINDW (SocialEmotinalStress,'Adherence')>0 THEN BS_Adherence=1; ELSE BS_Adherence=0;
IF FINDW (SocialEmotinalStress,'Chronic Disease')>0 THEN BS_Chronic=1; ELSE BS_Chronic=0;
IF FINDW (SocialEmotinalStress,'Social Support/Isolation')>0 THEN BS_Social=1; ELSE BS_Social=0;
IF FINDW (SocialEmotinalStress,'Lack of Access/Financial Resources')>0 THEN BS_Access=1; ELSE BS_Access=0;
IF FINDW (upcase(SocialEmotinalStress),upcase('Medical Condition'))>0 THEN BS_Medical=1; ELSE BS_Medical=0;
IF FINDW (SocialEmotinalStress,'Mental Health Conditions')>0 THEN BS_Mental=1; ELSE BS_Mental=0;
IF FINDW (SocialEmotinalStress,'Other')>0 THEN BS_Other1=1; ELSE BS_Other1=0;
IF FINDW (SocialEmotinalStress,'Trauma')>0 THEN BS_Trauma=1; ELSE BS_Trauma=0;
IF FINDW (SocialEmotinalStress,'Stressor')>0 THEN BS_Stressor=1; ELSE BS_Stressor=0;
IF FINDW (SocialEmotinalStress,'Violence and intimate partner violence (IPV)')>0 THEN BS_IPV=1; ELSE BS_IPV=0;

Re: FINDW FUNCTION ISNT'T CAPTURING ALL THE OBSERVATIONS

PaigeMiller — Thu, 01 Jun 2023 22:53:11 GMT

Please share a portion of the data you are using, along with the desired output for this portion of the data. Please provide the data as working SAS data step code (examples and instructions); and do not provide the data in other forms.

Re: FINDW FUNCTION ISNT'T CAPTURING ALL THE OBSERVATIONS

Reeza — Thu, 01 Jun 2023 23:00:56 GMT

I notice you use upcase in the first one, but not in the second. Have you confirmed the case and spelling matches exactly? Are you aware of the it modifiers for the FINDW() function?
You may also want to consider an array instead. It will keep the code much cleaner and easier to follow.

Re: FINDW FUNCTION ISNT'T CAPTURING ALL THE OBSERVATIONS

SASKiwi — Thu, 01 Jun 2023 23:01:31 GMT

You are searching for multiple word matches but using the single word function search FINDW. Try FIND or INDEX instead.

Re: FINDW FUNCTION ISNT'T CAPTURING ALL THE OBSERVATIONS

Reeza — Thu, 01 Jun 2023 23:08:52 GMT

array _words(3) _temporary_ $50. ('Unstable Housing', 'Adherence', 'Chronic Disease'); *Fill in rest of terms;

array _BS(3) BS_housing bs_adherence bs_chronic; *fill in rest of variables;

do i=1 to dim(_words);
IF FIND (SocialEmotinalStress, _words(i), 'it')>0 THEN _bs(i)=1; ELSE _bs(i)=0;
end;

FIND documentation

Modifiers (i/t)

i or I

ignores character case during the search. If this modifier is not specified, FIND searches only for character substrings with the same case as the characters in substring.

t or T

trims trailing blanks from string and substring.

Edited to FIND based on @SASKiwi answer.

@bn820 wrote:

The FINDW function is returning smaller count of observations compared to the dataset. e.g) The code returns a freq of 5 for adherence but the actual count is 8 in the dataset. Below is my code:

IF FINDW (upcase(SocialEmotinalStress),upcase('Unstable Housing'))>0 THEN BS_Housing=1; ELSE BS_Housing=0;
IF FINDW (SocialEmotinalStress,'Adherence')>0 THEN BS_Adherence=1; ELSE BS_Adherence=0;
IF FINDW (SocialEmotinalStress,'Chronic Disease')>0 THEN BS_Chronic=1; ELSE BS_Chronic=0;
IF FINDW (SocialEmotinalStress,'Social Support/Isolation')>0 THEN BS_Social=1; ELSE BS_Social=0;
IF FINDW (SocialEmotinalStress,'Lack of Access/Financial Resources')>0 THEN BS_Access=1; ELSE BS_Access=0;
IF FINDW (upcase(SocialEmotinalStress),upcase('Medical Condition'))>0 THEN BS_Medical=1; ELSE BS_Medical=0;
IF FINDW (SocialEmotinalStress,'Mental Health Conditions')>0 THEN BS_Mental=1; ELSE BS_Mental=0;
IF FINDW (SocialEmotinalStress,'Other')>0 THEN BS_Other1=1; ELSE BS_Other1=0;
IF FINDW (SocialEmotinalStress,'Trauma')>0 THEN BS_Trauma=1; ELSE BS_Trauma=0;
IF FINDW (SocialEmotinalStress,'Stressor')>0 THEN BS_Stressor=1; ELSE BS_Stressor=0;
IF FINDW (SocialEmotinalStress,'Violence and intimate partner violence (IPV)')>0 THEN BS_IPV=1; ELSE BS_IPV=0;

Re: FINDW FUNCTION ISNT'T CAPTURING ALL THE OBSERVATIONS

bn820 — Fri, 09 Jun 2023 16:44:43 GMT

Thanks everyone! These were vryhelpful

Re: FINDW FUNCTION ISNT'T CAPTURING ALL THE OBSERVATIONS

SASKiwi — Fri, 09 Jun 2023 22:31:49 GMT

@bn820 - Please update your post as answered in that case.

Re: FINDW FUNCTION ISNT'T CAPTURING ALL THE OBSERVATIONS

Tom — Sat, 10 Jun 2023 18:01:33 GMT

@SASKiwi wrote:

You are searching for multiple word matches but using the single word function search FINDW. Try FIND or INDEX instead.

FINDW works fine for finding multiple word matches. As long as the words are in the same order with the separation between the words in the string being searched as they appear in the strings being looked for.

findw('a b c d e','b c',' ')

Will find 'b c' in 'a b c d e'.

But

findw('a b c d e','b    c',' ')

Will not match.

Re: FINDW FUNCTION ISNT'T CAPTURING ALL THE OBSERVATIONS

bn820 — Mon, 12 Jun 2023 16:55:21 GMT

Sorry. I am new to SAS community. I am still learning.

Re: FINDW FUNCTION ISNT'T CAPTURING ALL THE OBSERVATIONS

Reeza — Mon, 12 Jun 2023 17:12:12 GMT

You usually mark the solution that is the answer, especially if there are multiple answers,.