Date: Wed, 5 Dec 2001 10:25:15 -0500
Reply-To: "Fehd, Ronald J." <rjf2@CDC.GOV>
Sender: "SAS(r) Discussion" <SAS-L@LISTSERV.UGA.EDU>
From: "Fehd, Ronald J." <rjf2@CDC.GOV>
Subject: Re: tip or trap: SQL and commercial rounding algorithm
Content-Type: text/plain; charset="iso-8859-1"
> From: Edward Heaton [mailto:HEATONE@WESTAT.com]
> Does this mean that business rounding only removes one
> decimal place, never
> more? Needless to say, I am beginning to believe that
> "business rounding" is the root of my poverty!! :-)
YeahBut, this is only a loss
when the digit to be rounded is 5 and the left digit is odd
you are a gainer the other 'half' of the time:
> uh, round 6.59 to an integer?
>
> x = Round(6.5,1,algorithm=Business/Commercial);
> put x=;
> x=7
happy now?!
Ron Fehd the WeAim2Please maven CDC Atlanta GA USA RJF2@cdc.gov
|