Date: Thu, 23 Dec 1999 15:24:50 +0100
Reply-To: Mike <m.hagendoorn@EARTHLINK.NET>
Sender: "SAS(r) Discussion" <SAS-L@LISTSERV.UGA.EDU>
From: Mike <m.hagendoorn@EARTHLINK.NET>
Organization: EarthLink Network, Inc.
Subject: Re: Replacing/Deleting an occurrence of a string in a field
The function you're looking for is TRANWRD. Here's how to do either (1) or
1) Get rid of all instances of " INC " and " CORP " in variable a:
a=TRANWRD(a, " INC", "");
a=TRANWRD(a, " CORP", "");
Note: The third argument is two double quotes with no blank in between.
2) Replace all instances " INC " with " CORP " in variable a:
a=TRANWRD(a, " INC", " CORP");
Hope this helps y'out, Happy Holidays,
LINCK, JIM <LINCK@SIMON.ROCHESTER.EDU> wrote in message
> I have an approximately 32 character field in a couple SAS data sets that
> am trying to match up. One of the problems caused in the matching is that
> INC " and " CORP " (with spaces so they are not part of the name) are
> sometimes mixed and matched. While I can easily compress out instances of
> single characters, I do not know how to compress out and/or replace
> instances of a whole string with another whole string. That is, I'd like
> do a couple things:
> 1. Get rid of all instances of " INC " and " CORP " in the variable
> 2. Replace all instances " INC " with " CORP "
> Any suggestions?