rounding value to next integer

[mlogan]

Hi All,

can anyone tell me the code how to round a data to it's next integer value? I know how to round down (9.81 to 9), but I don't know how to round up (9.01 to 10) 

here is the code I know for rounding except rounding to the next integer.

data round;

input no;

datalines;

9.9

9.4

9.5

9.047

9.55

9.006

9.004

9.999

9.6

9.1

;

run;

data newround;

set round;

value1 = round(no);      *rounding to the nearest integer;

value2 = int(no);     *Keep the integer only;

value3 = round(no,0.01); *rounding to the nearest second decimal;

run;

Thanks,

[billfish · Accepted solution]

you may try using the ceil() function.

value4 = ceil(no);

[mlogan]

thanks, it's working!!!

[Reeza]

If the solution above works for you please mark this (and other) questions as answered.