How to find position of selective word in entire character column observation

[Veeresh]

In the below example total 6 words are present.

I know the word ex: countries but i don't know at which position this word is present in a entire observation. 

I have to find position of the selective word in a complete sentence.

data ds;

  remark="most populated countries in the world";

run;

Passing word - "countries"

required output- 3

because countries word occurred at 3 position 

I have tried with findw, indexw, but unable to get required output because charterer by character results.

[gamotte · Accepted solution]

Hello,

You can use the findw function as follows :

pos=findw(remark, "countries",' ','e');

[ed_sas_member]

Hi @Veeresh 

As mentioned by @gamotte , the E modifier in 4th argument of the FINDW() function tells SAS to count the number of words instead of returning the starting position. The modifier argument must be positioned after the delimiter argument, which is the 3rd one.

Best,