how to round up number ?

[deleted_user]

if I have number -0.36, I want to have -1 or
-1.2 I want to have -2

how to round up it ?
thanks in advance.

[ieva]

Hi!

Use function Floor.

data test;
input num_a;
num_b=floor(num_a);
datalines;
-0.36
-1.2
0.36
1.2
;
run;

It gives results exactly the way you wanted:
num_a num_b
-0.36 -1
-1.2 -2
0.36 0
1.2 1

[sbb]

Just for clarification - given the examples you showed, I would say you are rounding down, not up.

CEIL function would round "UP".
FLOOR function would round "DOWN".

The SAS support website http://support.sas.com/ has technical papers (user community - SUGI, SGF) and SAS product documentation for reference -- links for example are provided below.

Scott Barry
SBBWorks, Inc.

SUGI/SGF paper - Introduction to SAS Functions
http://www2.sas.com/proceedings/sugi24/Begtutor/p57-24.pdf


SAS 9.2 DOC - CEIL Function:
http://support.sas.com/documentation/cdl/en/lrdict/59540/HTML/default/a000207949.htm

FLOOR function:
http://support.sas.com/documentation/cdl/en/lrdict/59540/HTML/default/a000207955.htm