topic Find position of substring in a string in SAS Programming

Find position of substring in a string

Rohit_1990 — Wed, 01 May 2019 18:41:47 GMT

Hi all,

In the below dataset I have 2 columns c and y with data as follows:

34 45 th avenue

South west 34 street

Column y

th avenue

street

So using column y I need to look in column x and if the 1stword is th in y and pattern matches in xthen I need to pull

The preceding digit

So my final output z would be something like this.

Column y

45 th avenue

street

Regards,

Rohit

Re: Find position of substring in a string

art297 — Wed, 01 May 2019 19:38:44 GMT

Something like the following should work:

data have (drop=position length);
  informat x y $30.;
  input x & y &;
  if scan(y,1) eq 'th' then do;
    call scan(x, FINDW(x, 'th',' ', 'e')-1, position, length);
    z=substr(x,position);
  end;
  else z=y;
  cards;
34 45 th avenue  th avenue
South west 34 street  street
;

Art, CEO, AnalystFinder.com

Re: Find position of substring in a string

ChrisNZ — Wed, 01 May 2019 23:16:53 GMT

Why don't you keep the street number in your example?

What do you do if there is no match?