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? ... View more

This code should work for you.  Does it not?   DATA MYDATA; New_address2 = tranwrd("123 E Eggers Street",' E ',' EAST '); RUN;     ... View more

Ah, ok.  Typically during the development phase you would want to pull and freeze the dataset in its entirety (if you can) onto your machine.  That way you need not hit the database overmuch.  You can do this either through MS SQL server via a temporary table (which automatically may create a local or global temporary table for you) or via SAS work library storage.   Also, an important distinction: A scheduled job is different than the scheduled task that I mentioned.  You may already know this, but a scheduled job is executed via database administrative systems, and a scheduled task is something that you can create on your desktop as a means of executing command line executables at certain times.   ... View more

Yet another way:   DATA MYDATA; LENGTH COL $7. COL1 $7.; INPUT COL COL1; CARDS; PARAM PARAMCD PARACD PARAM AVAL AVALC AVALC AVAL AVISIT AVISTIN AVISITN AVISIT AVISIT AVAL AVAL PARAMCD ; RUN;     DATA MYDATA; SET MYDATA; LENGTH REMAINDER $ 15; IF INDEX(TRIM(COL1), TRIM(COL)) > 0 THEN DO; REMAINDER = TRANWRD(TRIM(COL1), TRIM(COL), ' '); END; RUN; ... View more

Add spaces before and after your search term?   New_address2 = tranwrd(New_address1,' E ','EAST') ... View more