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.
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;
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.
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;
Hi Arthur,
That worked very good for what I was trying to do.
Thank you so much
Join us for SAS Innovate April 16-19 at the Aria in Las Vegas. Bring the team and save big with our group pricing for a limited time only.
Pre-conference courses and tutorials are filling up fast and are always a sellout. Register today to reserve your seat.
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.