topic Re: Floor function in SAS in SAS Programming

Floor function in SAS

IGD — Fri, 08 Oct 2021 08:18:56 GMT

Hi everyone,

I cannot make sense of this output.

c=(abs(-2.271120)*100000);
d=floor(c);

output:

c=227112

d=227111

I expected to see d=227112 why i am getting this result?

FreelanceReinh — Fri, 08 Oct 2021 08:42:03 GMT

Hi @IGD and welcome to the SAS Support Communities!

Use the ROUND function to avoid the issue

c=round(abs(-2.271120)*100000,1e-8);

and see the 2015 thread ceil function bug? for explanations.

acordes — Fri, 08 Oct 2021 08:45:46 GMT

I suppose it has to do with the floating points.

Try

data _null_;

format b c d best12.;

b=abs(-2.271120);

c=(abs(-2.271120)*100000);
d=floor(c);

put b= c= d= ;

run;

IGD — Fri, 08 Oct 2021 09:56:05 GMT

it is giving me

b=2.27112 c=227112 d=227111 so it did not work but thank you for replying

IGD — Fri, 08 Oct 2021 09:59:02 GMT

this worked thank you very much