Date:         Mon, 5 Jun 2000 08:34:10 EDT
Reply-To:     Bernard Tremblay <imaginasys@HOTMAIL.COM>
Sender:       "SAS(r) Discussion" <SAS-L@LISTSERV.UGA.EDU>
From:         Bernard Tremblay <imaginasys@HOTMAIL.COM>
Subject:      Re: Strange Behaviour
Comments: To: subramaniam.baskaran@DB.COM
Content-Type: text/plain; charset=iso-8859-1; format=flowed

Hi BAskar,

   Simple.  The PROC FORMAT does not round values and the format used when
you view the data does round ...  If my memory is good you can't do nothing
with this but round yourself the figures before you write them to the file.

       Regards,

         \\\|///
       \\  - -  //
        (  @ @  )
+-----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@quebectel.com       |
|                    | Hot:  imaginasys@hotmail.com      |
+--------------Oooo--+-----------------------------------+
       oooO   (   )
      (   )    ) /
       \ (    (_/
        \_)
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~



>From: Baskaran Subramaniam <subramaniam.baskaran@DB.COM>
>Reply-To: subramaniam.baskaran@DB.COM
>To: SAS-L@LISTSERV.UGA.EDU
>Subject: Strange Behaviour
>Date: Mon, 5 Jun 2000 17:15:15 +0530
>
>Hello Listusers
>
>
>We have a library with some tables, these tables have some value fields
>with length as 8 and format as 15.2.
>After formatting these values, it has to be written into an external file .
>For formatting, I am using the following proc
>
>PROC FORMAT;
>      PICTURE RSIGN
>      LOW-<0 = '999999999999.99-'
>      0-HIGH = '999999999999.99 '
>      ;
>
>
>After running the job, when I checked the output , I found a strange
>behaviour. Some of the
>values are decremented by .01 (compared to that displayed in the online
>SAS).
>
>This is not happening in all the fields but only happening in selective
>records and fields.
>I am unable to establish any pattern for this and also unable to understand
>this behaviour also.
>
>Could somebody advise me on the possible reasons and the corrective
>measures.
>
>TIA
>Rgds
>Baskar




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