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

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

Veeresh — Tue, 11 Feb 2020 10:00:22 GMT

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.

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

gamotte — Tue, 11 Feb 2020 10:02:54 GMT

Hello,

You can use the findw function as follows :

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

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

ed_sas_member — Tue, 11 Feb 2020 10:25:42 GMT

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,