topic Re: round function in SAS Programming

round function

CathyVI — Sun, 22 Sep 2019 18:25:07 GMT

I am asked to round 345.653 to the nearest integer values.

I used x=round(345.653, 1) and i got 346.000 is this the correct answer ? I was expecting 345 as my answer. How can i get 345 ?

Re: round function

novinosrin — Sun, 22 Sep 2019 18:30:54 GMT

What you wrote sounds like you'd rather prefer INT than a ROUND up/down. Can you confirm?

If yes, use

x=int(345.653)

Re: round function

CathyVI — Sun, 22 Sep 2019 18:44:16 GMT

my goal is to change 345.653 to 346

Re: round function

novinosrin — Sun, 22 Sep 2019 18:49:48 GMT

In that case, all you need is

x=round(345.653)  ;

Re: round function

Kurt_Bremser — Sun, 22 Sep 2019 18:52:15 GMT

@CathyVI wrote:

I am asked to round 345.653 to the nearest integer values.

I used x=round(345.653, 1) and i got 346.000 is this the correct answer ? I was expecting 345 as my answer. How can i get 345 ?

It is the correct value for the typically used "round half up" method. Anything from 345.5 and up is rounded up to 346.

Re: round function

CathyVI — Sun, 22 Sep 2019 18:54:03 GMT

the x=int(345.653) worked. I was able to get 346 but i have to create another variable
for example v1= int(345.653) = 346 but when i did
v1= int(v1), i got the 345.000.
Thank you

Re: round function

PaigeMiller — Sun, 22 Sep 2019 18:59:05 GMT

INT doesn't work here. You need to use ROUND().

Re: round function

Reeza — Mon, 23 Sep 2019 01:51:16 GMT

INT() grabs the integer portion ignoring the decimal component entirely.

ROUND() rounds to the nearest interval - where you can specify what interval you want, with the default being 1.

Nearest interval varies because you can round to the nearest 1, 5, 10 or 15 in SAS which is often quite convenient.

In this case, your number is 345.653 which is closer to 346 rather than 345 so 346 is the correct value when rounding to the nearest integer.

You need to decide which one you want to use, but both work appropriately.

@CathyVI wrote:

I am asked to round 345.653 to the nearest integer values.

I used x=round(345.653, 1) and i got 346.000 is this the correct answer ? I was expecting 345 as my answer. How can i get 345 ?