topic Re: replace in New SAS User

replace

Smitha9 — Tue, 07 Jul 2020 15:22:46 GMT

Hi ,

I have dru-26-12345

pru-26-56743

I want to change 26 to 34

dru-34-12345

pru-34-56743

please let me know.

thank you

Re: replace

Shmuel — Tue, 07 Jul 2020 15:42:01 GMT

option 1 - use tranwrd function,

option 2 - use prxchange function

as shown in next log output:

72         
 73         data _null_;
 74           txt = 'dru-26-12345';
 75           txt1 = prxchange('s/26/34/',-1,txt); put txt1=;
 76           txt2 = tranwrd(txt,'26','34'); put  txt2=;
 78         run;
 
 txt1=dru-34-12345
 txt2=dru-34-12345

Re: replace

novinosrin — Tue, 07 Jul 2020 15:49:09 GMT


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;

Re: replace

Shmuel — Tue, 07 Jul 2020 15:43:49 GMT

The 's' in prxchange stands for 'substitute'/

'tranwrd' stands for translate word.

Re: replace

novinosrin — Tue, 07 Jul 2020 17:28:23 GMT


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;

Re: replace

Ksharp — Wed, 08 Jul 2020 13:35:57 GMT

Better this.
prxchange('s/\b26\b/34/',-1,txt)
or
prxchange('s/-26-/-34-/',-1,txt)
otherwise , if txt1=dru-26-12326 , would get wrong result.