Date:         Mon, 5 Jun 2000 19:44:18 +0530
Reply-To:     subramaniam.baskaran@DB.COM
Sender:       "SAS(r) Discussion" <SAS-L@LISTSERV.UGA.EDU>
From:         Baskaran Subramaniam <subramaniam.baskaran@DB.COM>
Subject:      Re: Strange Behaviour
Comments: To: peter.crawford@db.com
Content-type: text/plain; charset=us-ascii

Hello All

Thanks for everybody who have responded and for sharing their knowledge. The Round option on format did what I wanted.
This brings me to a question

If the format used to view rounds off, then what is the real value and how can I see it or I can write it to an external file..... Is the rounded off value is valid?

Am I missing out something , which is basic?


Thanks once again
Rgds
Baskar




---------------------------------------- Message History ----------------------------------------


From: peter.crawford@db.com on 06/05/2000 01:46 PM GMT

Please respond to peter.crawford@db.com

To:   SAS-L@listserv.uga.edu
cc:
Subject:  Re: Strange Behaviour



BAskar should try it with the ROUND option on the format.
  >PROC FORMAT;
>      PICTURE RSIGN(round)
>      LOW-<0 = '999999999999.99-'
>      0-HIGH = '999999999999.99 '
>      ;
>


Datum:         05.06.2000 14:33
An:            SAS-L@listserv.uga.edu




Antwort an:    imaginasys@hotmail.com

Betreff:       Re: Strange Behaviour
Nachrichtentext:


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