Help using Base SAS procedures

Find alphanumeric string within a string

Accepted Solution Solved
Reply
Super Contributor
Posts: 398
Accepted Solution

Find alphanumeric string within a string

Hello,

I'm having a hard time getting the position of an alphanumeric string within another string.

Example.

a='abcdefgh1zzbxasefe' ;

b='1zz' ;

How can I find the position of b within a?  When there are spaces it works but I can't find the correct function to get me this information like this.  I've tried find, findw.

Any help would be appreciated.


Accepted Solutions
Solution
‎02-27-2014 04:50 PM
PROC Star
Posts: 7,362

Re: Find alphanumeric string within a string

The index function would work too.  e.g.:

data test;

  a='abcdefgh1zzbxasefe' ;

  b='1zz' ;

  c='gh1';

  d='xxx';

  testb=index(a,b);

  testc=index(a,c);

  testd=index(a,d);

run;

View solution in original post


All Replies
Super Contributor
Posts: 398

Re: Find alphanumeric string within a string

I think I figured it out.  All the time I spent searching and testing and not until I post my question do I get it working.

I used this approach

data z;

  x = prxmatch('m/1zz|2ex/oi', 'abcdefgh1zzbxasefe') ; 

run ;

I get x=9 back.

Solution
‎02-27-2014 04:50 PM
PROC Star
Posts: 7,362

Re: Find alphanumeric string within a string

The index function would work too.  e.g.:

data test;

  a='abcdefgh1zzbxasefe' ;

  b='1zz' ;

  c='gh1';

  d='xxx';

  testb=index(a,b);

  testc=index(a,c);

  testd=index(a,d);

run;

Super Contributor
Posts: 398

Re: Find alphanumeric string within a string

Hi Arthur,

That worked very good for what I was trying to do.

Thank you so much

☑ This topic is SOLVED.

Need further help from the community? Please ask a new question.

Discussion stats
  • 3 replies
  • 179 views
  • 3 likes
  • 2 in conversation