topic Re: rounding value to next integer in SAS Data Science

rounding value to next integer

mlogan — Tue, 02 Jun 2015 23:00:44 GMT

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,

Re: rounding value to next integer

billfish — Tue, 02 Jun 2015 23:11:23 GMT

you may try using the ceil() function.

value4 = ceil(no);

Re: rounding value to next integer

mlogan — Wed, 03 Jun 2015 00:05:40 GMT

thanks, it's working!!!

Re: rounding value to next integer

Reeza — Wed, 03 Jun 2015 00:21:46 GMT

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