Using regular expressions for deletion

[mansour_ib_sas]

Hello,

i want to delete the 3 numbers that are in the middle.

I tried like this; It does not work.

Will you please help me

thank you

data test;
input name $;
cards;
901-333-444
;run;


proc sql;
select name
      , prxchange( 's/\A -\d{3} / /i',-1,name ) as name1
 from test
 ;
 quit ;

[Jagadishkatam · Accepted solution]

please try

data test;
input name $20.;
name1=prxchange('s/(\d{1,3})\-(\d{1,3})\-(\d{1,3})/$1-$3/i',-1,strip(name));
put name1;
cards;
901-333-444
;
run;

[PGStats]

Use

prxchange('s/-\d+-/-/o', 1, name)