data have;
var='dru-26-12345';
output;
var='pru-26-56743';
output;
run;
data want;
set have;
var1=prxchange('s/([a-z]{3})-(26)-(\d{5})/$1-34-$3/i', -1, var);
run;
data have;
var='dru-26-12345';
output;
var='pru-26-56743';
output;
run;
data want;
set have;
if substr(var,5,2)='26' then substr(var,5,2)='34';
run;
/*OR*/
data want;
set have;
if scan(var,2,'-')='26' then substr(var,5,2)='34';
run;
Register Today!
Join us for SAS Innovate 2025, our biggest and most exciting global event of the year, in Orlando, FL, from May 6-9. Sign up by March 14 for just $795.