Date:         Mon, 25 Oct 2010 09:13:05 -0500
Reply-To:     Joe Matise <snoopy369@GMAIL.COM>
Sender:       "SAS(r) Discussion" <SAS-L@LISTSERV.UGA.EDU>
From:         Joe Matise <snoopy369@GMAIL.COM>
Subject:      Re: TRANWRDing carriage returns?
Comments: To: "Wall, Steven" <steve.wall@pioneer.com>
In-Reply-To:  <5D9C0156B56FD049828197854F6DD64A0B79D47AB2@jhms40.phibred.com>
Content-Type: text/plain; charset=ISO-8859-1

CR is '0D'x if you mean just that one character.  Normal DOS/Windows end of
line characters are '0D'x'0A'x (CR/LF).

You would use TRANSLATE not TRANWRD to change just one character value
(although I suppose tranwrd also would work, it's overkill).

-Joe

On Mon, Oct 25, 2010 at 9:09 AM, Wall, Steven <steve.wall@pioneer.com>wrote:

> SAS-Lers,
>
> I have a text variable with values that (I think) contain embedded carriage
> returns.
> Can I use the TRANWRD function to change them into 'dashes'?
> If so, what do I put in the function call?
>
> NewVar= tranwrd(OldVar,???,'-') ;
>
> Thanks.
> SJ Wall
>
>
> This communication is for use by the intended recipient and contains
> information that may be Privileged, confidential or copyrighted under
> applicable law. If you are not the intended recipient, you are hereby
> formally notified that any use, copying or distribution of this e-mail,
> in whole or in part, is strictly prohibited. Please notify the sender by
> return e-mail and delete this e-mail from your system. Unless explicitly
> and conspicuously designated as "E-Contract Intended", this e-mail does
> not constitute a contract offer, a contract amendment, or an acceptance
> of a contract offer. This e-mail does not constitute a consent to the
> use of sender's contact information for direct marketing purposes or for
> transfers of data to third parties.
>
> Francais Deutsch Italiano  Espanol  Portugues  Japanese  Chinese  Korean
>
>           http://www.DuPont.com/corp/email_disclaimer.html
>