topic Re: Nth Occurance as word in a string without regex in SAS Programming

Nth Occurance as word in a string without regex

BrahmanandaRao — Wed, 11 Oct 2023 07:17:59 GMT

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

Re: Nth Occurance as word in a string without regex

s_lassen — Wed, 11 Oct 2023 07:39:46 GMT

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.

Re: Nth Occurance as word in a string without regex

Amir — Wed, 11 Oct 2023 07:43:54 GMT

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.

Re: Nth Occurance as word in a string without regex

Kurt_Bremser — Wed, 11 Oct 2023 07:48:03 GMT

Use the FINDW Function with the proper modifier.

Re: Nth Occurance as word in a string without regex

Kurt_Bremser — Wed, 11 Oct 2023 07:54:30 GMT

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"?

Re: Nth Occurance as word in a string without regex

BrahmanandaRao — Wed, 11 Oct 2023 09:11:47 GMT

Hi Kurt

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

Re: Nth Occurance as word in a string without regex

Kurt_Bremser — Wed, 11 Oct 2023 10:05:11 GMT

@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.