topic Using regular expressions for deletion in SAS Programming

Using regular expressions for deletion

mansour_ib_sas — Tue, 11 Dec 2018 16:50:13 GMT

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 ;

Re: Using regular expressions for deletion

Jagadishkatam — Tue, 11 Dec 2018 17:07:41 GMT

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;

Re: Using regular expressions for deletion

PGStats — Tue, 11 Dec 2018 18:46:27 GMT

Use

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