topic converting -0.00 to 0.00 in SAS Programming

converting -0.00 to 0.00

mansour_ibrahim — Fri, 15 Dec 2017 19:31:52 GMT

Hello,

I want to get a 0.00 from this value -1.42109E-14.

With best32. I have -0.00

Thank you

Cordially

Re: converting -0.00 to 0.00

ChrisHemedinger — Fri, 15 Dec 2017 19:59:44 GMT

This is a nuance of floating point representation. See What's the difference between 0 and -0?

You might consider using the ROUND function, or multiplying the value by 1.0 might do the trick.

Re: converting -0.00 to 0.00

WarrenKuhfeld — Fri, 15 Dec 2017 20:02:28 GMT

This would be one way to display values near zero as zero. No doubt others will chime in with other ways.

proc format;
   value myfmt -1e-12 - 1e-12 = '                            0.00';
run;

data x;
   do i = -1 to 1 by 0.1;
      j = i;
      output;
   end;
   format i best32. j myfmt32.;
 run;
   
proc print; run;