Date:         Thu, 21 Dec 2000 14:57:04 -0500
Reply-To:     Bernard Tremblay <imaginasys@HOTMAIL.COM>
Sender:       "SAS(r) Discussion" <SAS-L@LISTSERV.UGA.EDU>
From:         Bernard Tremblay <imaginasys@HOTMAIL.COM>
Subject:      Re: Right or Left Justifying Character Values
Comments: To: johndangelo@WORLDNET.ATT.NET
Content-Type: text/plain; charset=iso-8859-1; format=flowed

Hi John,

   How about the TRIM() function ?

         Happy Hollidays to all on the SAS-L,
            0
           / \
         \\\|///
       \\  - -  //
        (  @ @  )
+-----oOOo-(_)-oOOo--+-----------------------------------+
| Bernard Tremblay   |                                   |
|            CSST    | Tel:  (418) 528-9313              |
|                    | Fax:  (418) 528-1493              |
|                    | Int:  Bernard.Tremblay@csst.qc.ca |
+----------------------------+---------------------------+
|    Imaginasys enr  | Res:  (418) 658-1411              |
|                    | Int:  bertrem@videotron.ca        |
|                    | Hot:  imaginasys@hotmail.com      |
+--------------Oooo--+-----------------------------------+
       oooO   (   )
      (   )    ) /
       \ (    (_/
        \_)
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
>From: johndangelo@WORLDNET.ATT.NET
>Reply-To: johndangelo@WORLDNET.ATT.NET
>To: SAS-L@LISTSERV.UGA.EDU
>Subject: Right or Left Justifying Character Values
>Date: Thu, 21 Dec 2000 19:21:44 GMT
>
>I am running a SAS job that is trying to match two files with a common
>character field.  When this ran, I found more mismatches than I had
>anticipated.  After investigating, I determined it was because the
>character field, although the same on both files, could have the same
>value in different positions of field.  For example, two 5 byte fields
>called Account can have a 3, 4 or 5 byte Account Number.  What I am
>finding is that the Account Numbers do not always start in position #1.
>
>Question:
>
>Is there a way to justify the character value so they all begin in
>position #1 of the field?
>
>ie:  Instead of __123, I need 123__ to be able to perform the match to
>the other file.
>
>Thanks in advance for your help!
>
>John
>
>
>Sent via Deja.com
>http://www.deja.com/


_________________________________________________________________________
Get Your Private, Free E-mail from MSN Hotmail at http://www.hotmail.com.