topic Re: Proc Tranwrd replacing a single letter in SAS Programming

Proc Tranwrd replacing a single letter

hwangnyc — Fri, 21 Apr 2017 18:46:04 GMT

Hi everyone,

I'm working on an address data set I have several addresses that have a "E" in place of "East" for example:

Instead of "123 E Eggers Street" I want 123 "East Eggers Street"

But when i use

New_address2 = tranwrd(New_address1,'E','EAST')

Every E is replaced with EAST. Is there anyway around this?

Thank you!

Re: Proc Tranwrd replacing a single letter

thomp7050 — Fri, 21 Apr 2017 18:57:25 GMT

Add spaces before and after your search term?

New_address2 = tranwrd(New_address1,' E ','EAST')

Re: Proc Tranwrd replacing a single letter

hwangnyc — Fri, 21 Apr 2017 19:17:44 GMT

Hi Thomp, thanks for the suggestion! I tried a couple of variations space before and after, after only, before only and EAST is still appearing at unexpected places. Any other thoughts?

Re: Proc Tranwrd replacing a single letter

thomp7050 — Fri, 21 Apr 2017 19:20:41 GMT

This code should work for you. Does it not?

DATA MYDATA;
New_address2 = tranwrd("123 E Eggers Street",' E ',' EAST ');
RUN;

Re: Proc Tranwrd replacing a single letter

hwangnyc — Fri, 21 Apr 2017 19:23:37 GMT

It does work except, I have other entries in the data set and what happens is Avenue becomes avenueast

Re: Proc Tranwrd replacing a single letter

thomp7050 — Fri, 21 Apr 2017 19:25:58 GMT

DATA MYDATA;
New_address2 = tranwrd("123 E Eggers Avenue",' E ',' EAST ');
RUN;

Produces "123 EAST Eggers Avenue", which I think is what you had hoped for (?) Was there an example that you tried using this process and printed EAST unexpectedly?

Re: Proc Tranwrd replacing a single letter

Reeza — Fri, 21 Apr 2017 19:26:21 GMT

You need to post a larger sample data set and identify which records are being incorrectly converted.

Include the code you're using as well and the log.

Re: Proc Tranwrd replacing a single letter

ballardw — Fri, 21 Apr 2017 19:37:37 GMT

The Tranwrd function is working as designed: (from online help) Replaces all occurrences of a substring in a character string.

You might look into FINDW to find the E as a word and then use other functions to insert the text.

One way:

data example;
   New_Address1 = "123 E Eggers Street";
   pos=findw(New_address1,'E');
   if pos>0 then New_address2 = catx(' ',substr(New_address1,1,Pos-1),"East",substr(New_address1,Pos+1));
run;

Note that will only change the first E

Re: Proc Tranwrd replacing a single letter

Ksharp — Sat, 22 Apr 2017 03:54:28 GMT

data example;
   New_Address1 = "123 E Eggers Street";
   New_address2 = prxchange('s/\bE\b/East/i',-1,New_address1);
run;