Remove Text

[Selli5]

Hello,

I have identified an error in within an address field and want to remove it.

Within an address field 'address_1'  there is occassionally an error ' -- Please Select -- ' written within it.  Is there a way to remove this phase from the address field?

thanks

Sally

[ChrisNZ]

Like this?

data HAVE;
  ADDRESS_1= ' foo  -- Please Select --  faa ';
  ADDRESS_1=tranwrd(ADDRESS_1,'-- Please Select --','');
  putlog ADDRESS_1=;
run;

ADDRESS_1=foo     faa

[kiranv_]

May be something like this

data abc;

input addr_ln_1 $50.;
datalines;
 -- Please Select --1121 berkeley street
 7755 cambridge ave
;
run;

data bde;
set abc;
addr_ln_1=tranwrd(addr_ln_1,'-- Please Select --','');
run;