Nth Occurance as word in a string without regex

[BrahmanandaRao]

Hi Guys,

Good Moring 

data nth_occurance;
c='who is this'  ;
run;

in the above string how to find  'is'      2nd occurrence position with out using any regex 

[s_lassen]

Beats me why you do not want to use REGEX. But here is a solution using the FIND function:

data want;
  set nth_occurance;
  pos=-1; /* 1-length(search string) */
  do _N_=1 to 2; /* N=2, here */
    pos=find(c,'is',pos+2); /* add length(search string) to starting position */
    if pos=0 then leave;
    end;
run;

The program returns a POS value of 0 if the nth occurrence is not in string.

[Amir]

Hi,

The find() function can accept an argument for the starting position for the search, so you can search for the first occurrence and then look for the 2nd occurrence after that. See code below for an example.

data nth_occurance;
  c = 'who is this';
  pos = find(c,'is',find(c,'is') + 1);
run;

Thanks & kind regards,

Amir.

[Kurt_Bremser]

Use the FINDW Function with the proper modifier.

[Kurt_Bremser]

BTW your question is very unclear. What do you want to find?

• the 2nd word?
• the number/position of the word "is", if contained?
• the 2nd appearance of the word "is"?

[BrahmanandaRao]

Hi Kurt

 I want to find 2nd occurrence position ' is'  in that text

[Kurt_Bremser]

---

@BrahmanandaRao wrote:

Hi Kurt

 I want to find 2nd occurrence position ' is'  in that text

---

Just reposting what you  already said won't help. Answer my questions.