BookmarkSubscribeRSS Feed
🔒 This topic is solved and locked. Need further help from the community? Please sign in and ask a new question.
jerry898969
Pyrite | Level 9

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.

1 ACCEPTED SOLUTION

Accepted Solutions
art297
Opal | Level 21

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

3 REPLIES 3
jerry898969
Pyrite | Level 9

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.

art297
Opal | Level 21

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;

jerry898969
Pyrite | Level 9

Hi Arthur,

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

Thank you so much

hackathon24-white-horiz.png

2025 SAS Hackathon: There is still time!

Good news: We've extended SAS Hackathon registration until Sept. 12, so you still have time to be part of our biggest event yet – our five-year anniversary!

Register Now

What is Bayesian Analysis?

Learn the difference between classical and Bayesian statistical approaches and see a few PROC examples to perform Bayesian analysis in this video.

Find more tutorials on the SAS Users YouTube channel.

SAS Training: Just a Click Away

 Ready to level-up your skills? Choose your own adventure.

Browse our catalog!

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