Building models with SAS Enterprise Miner, SAS Factory Miner, SAS Visual Data Mining and Machine Learning or just with programming

rounding value to next integer

Reply
Regular Contributor
Posts: 215

rounding value to next integer

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,

Contributor
Posts: 52

Re: rounding value to next integer

you may try using the ceil() function.

value4 = ceil(no);

Regular Contributor
Posts: 215

Re: rounding value to next integer

thanks, it's working!!!

Super User
Posts: 17,840

Re: rounding value to next integer

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

Ask a Question
Discussion stats
  • 3 replies
  • 431 views
  • 0 likes
  • 3 in conversation