how to extract 'dd' word

[thanikondharish]

data ex1;
name='aaa234bbb$&#^#*abrrtbbrtbbb';
output;
name='harbbdgetbb' ;
output;
run;

I have one dataset like see above dataset so how to extract 'bb' wherever the string has only 'bb' word(onlu two letters) pick that position

like see below dataset

name                                                   position

aaa234bbb$&#^#*abrrtbbrtbbb             21

harbbdgetbb                                         4

[VDD]

There are many examples in the search results and I have 2  results that will assist you.  

https://communities.sas.com/t5/General-SAS-Programming/Extracting-word-from-string/m-p/320572#M42293

https://communities.sas.com/t5/New-SAS-User/how-to-extract-key-words-from-variables/m-p/527321#M5262

[Tom]

You could use CALL SCAN() in a loop.   Treat any character other than 'b' as a delimiter. Look at each "word" and stop when you find one that is length of 2.

data have ;
  input name $50. ;
cards;
aaa234bbb$&#^#*abrrtbbrtbbb
harbbdgetbb
xxxbbyyy
bbzzz
none
;

data want ;
  set have;
  do i=1 by 1 until(len in (0,2)) ;
    pos=sum(pos,len,0);
    call scan(name,i,pos,len,compress(name,'b'));
  end;
  put (i pos len name) (=);
run;

Result

i=3 pos=21 len=2 name=aaa234bbb$&#^#*abrrtbbrtbbb
i=1 pos=4 len=2 name=harbbdgetbb
i=1 pos=4 len=2 name=xxxbbyyy
i=1 pos=1 len=2 name=bbzzz
i=1 pos=0 len=0 name=none

[thanikondharish]

Thanq now I learnt one new thing

[VDD]

@thanikondharish that is great you learn and acknowledge that please mark the solution that assist you thank you.