topic Remove Text in SAS Programming

Remove Text

Selli5 — Fri, 09 Jun 2017 03:43:00 GMT

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

Re: Remove Text

ChrisNZ — Fri, 09 Jun 2017 03:59:29 GMT

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

Re: Remove Text

kiranv_ — Fri, 09 Jun 2017 03:59:47 GMT

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;