topic Re: find function - negative starting position in SAS Programming

find function - negative starting position

AlexeyS — Tue, 07 Apr 2020 10:15:47 GMT

Hello,

I want to understand starting position parameter in find function.

data test;
 xyz='She sells seashells? Yes, she does.';                                                                                             
   startposexp=-22;                                                                                                                      
   whereisShe_ineg22=find(xyz,'She','i',startposexp);                                                                                     
   put whereisShe_ineg22=;  
run;

In this example whereisShe_ineg22=14, Why?

As i understand, because the start position is negative, we start at the end of the string and count 22 places, and get the character s. Then the function start search to left, and to right. Why? please see

https://documentation.sas.com/?docsetId=lefunctionsref&docsetTarget=p00ab6ey29t2i8n1ihel88tqtga9.htm&docsetVersion=3.1&locale=en

Thank you

Re: find function - negative starting position

PaigeMiller — Tue, 07 Apr 2020 11:48:34 GMT

The -22 tells SAS to begin the search at the 22nd character starting from the right, which is the first s of "seashells". It then finds the string 'She' (ignoring case) beginning at character 14 of the string (which is in the inside of the word "seashells").

Re: find function - negative starting position

Tom — Tue, 07 Apr 2020 14:18:59 GMT

You are not understanding how it uses the absolute value when the starting position is negative.

The first place where 'she' appears when searching backwards from byte 22 is byte 14.

Does this picture help?

She sells seashells? Yes, she does.
----+----0----+----0----+----0----+
             ^       ^
             |       +-> Position 22
             +> Position 14

actually if you change the search string from SHE to YES you can see that appear to behave as if it truncated the string at that position and then searches from the end of the truncated string backwards. With a starting position of 24 or larger it finds YES when searching backwards. But it does not find it when starting in position 22 or 23.

Re: find function - negative starting position

AlexeyS — Tue, 07 Apr 2020 14:39:22 GMT

Hi Tom, i am still confused.
This definition i read in sas page : start-position is specified, the absolute value of start-position determines the position at which to start the search. The sign of start-position determines the direction of the search.

I have to solution, which one is correct?
1. because start position is negative, i find position 22 from right to left, and then the search is standard from left to right?
2. to find start position i always use absolute value, i.e i find 22 position from left to right, and then because the direction is negative, i will look for the first occurrence of "she" from right to left?

Thank you

Re: find function - negative starting position

Tom — Tue, 07 Apr 2020 15:09:46 GMT

Your second description is right.

Absolute value of POSITION determines where to start the search. SIGN of position determines the direction to search. The result is always location when counting from left, and is always positive. (or zero when not found).