Find position of substring in a string

[Rohit_1990]

Hi all,

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

X

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

[art297]

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

[ChrisNZ]

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

What do you do if there is no match?