Duck,

For the 1/2 problem, is it a symbol as you can find in MS-Word or simply the faction ?

Stéphane.

-----Message d'origine----- De : SAS(r) Discussion [mailto:SAS-L@LISTSERV.UGA.EDU] De la part de Toby Dunn Envoyé : mardi 24 février 2004 20:16 À : SAS-L@LISTSERV.UGA.EDU Objet : Re: removing '1/2' from address

I see says the blind man!!! Well I stand corrected I guess it really was a long night. Thanks for the catch and explanation Venky..

Toby Dunn

-----Original Message----- From: SAS(r) Discussion [mailto:SAS-L@LISTSERV.UGA.EDU] On Behalf Of Chakravarthy, Venky Sent: Tuesday, February 24, 2004 1:01 PM To: SAS-L@LISTSERV.UGA.EDU Subject: Re: removing '1/2' from address

Toby,

DuckHye's COMPRESS specified the character set that needs to be eliminated. Since a space was not specified, it did not eliminate any self contained spaces. Yours is an unconditional COMPRESS, meaning it compresses spaces by default.

88 data _null_ ; 89 address = "My Street 1/2 that has 1, 2 and a /" ; 90 DuckHye = compress(address,"1/2") ; 91 Toby = compress(tranwrd(address,"1/2","")) ; 92 put (_all_) (/ =) ; 93 run ;

address=My Street 1/2 that has 1, 2 and a / DuckHye=My Street that has , and a Toby=MyStreetthathas1,2anda/

_________________________________ Venky Chakravarthy E-mail: swovcc_AT_hotmail_DOT_com

-----Original Message----- From: Toby Dunn [mailto:tdunn@OAKHILLTECH.COM] Sent: Tuesday, February 24, 2004 12:16 PM To: SAS-L@LISTSERV.UGA.EDU Subject: Re: removing '1/2' from address

Venky,

Thanks for the catch of the right paren. Late nights with a sick baby and my eyes and brain are very blurry. As for the compressing out blank spaces I was going off what he did in his example where he did compress out blanks.

Toby Dunn

-----Original Message----- From: Chakravarthy, Venky [mailto:Venky.Chakravarthy@pfizer.com] Sent: Tuesday, February 24, 2004 11:00 AM To: 'Toby Dunn' Subject: RE: removing '1/2' from address

Toby,

A missing right paren and the undesirable effect of compressing out spaces in the address:

44 data _null_ ; 45 street = "My 1 Street 2 / 1/2" ; 46 street=compress(tranwrd(street,"1/2","")); 47 *substr(street,index(street,"1/2"),3) = "" ; 48 put street = ; 49 run ;

street=My1Street2/

_________________________________ Venky Chakravarthy E-mail: swovcc_AT_hotmail_DOT_com

-----Original Message----- From: Toby Dunn [mailto:tdunn@OAKHILLTECH.COM] Sent: Tuesday, February 24, 2004 11:55 AM To: SAS-L@LISTSERV.UGA.EDU Subject: Re: removing '1/2' from address

Duck,

Try this: street=compress(tranwrd(street,"1/2","");

HTH Toby Dunn

-----Original Message----- From: SAS(r) Discussion [mailto:SAS-L@LISTSERV.UGA.EDU] On Behalf Of Duck-Hye Yang Sent: Tuesday, February 24, 2004 10:16 AM To: SAS-L@LISTSERV.UGA.EDU Subject: removing '1/2' from address

Hi, when I did street=compress(street, '1/2'), I found that all individual items (1, /, 2) were gone from street. I wanted to remove the whole thing, 1/2. How can I do that?

Thanks, Duckhye

LEGAL NOTICE Unless expressly stated otherwise, this message is confidential and may be privileged. It is intended for the addressee(s) only. Access to this E-mail by anyone else is unauthorized. If you are not an addressee, any disclosure or copying of the contents of this E-mail or any action taken (or not taken) in reliance on it is unauthorized and may be unlawful. If you are not an addressee, please inform the sender immediately.