excel round equation in sas

dht115 — Thu, 17 Feb 2022 22:13:53 GMT

Hello,

I do have following equation in excel.

=ROUND(((SUM(O206+Q206+S206+U206+W206+Y206+AA206+AC206+AE206+AG206+AI206+AK206)-BK206)/11),0)

Here, Column "O" to Column "AK206" are my dmd data

Column "BK" is my maxtwelve

I use following equation in sas.

round = round((sum(of Dmd1-Dmd12)-maxtwelve)/11);

In some incident, I am not getting same result.

For example if Excel produce -66.45454545, Excel Output is -66. Whereas SAS output is -67.

If I use

int = int((sum(of Dmd1-Dmd12)-maxtwelve)/11);

In some incident, I am not getting same result.

For example if Excel produce -463.5454545, Excel Output is -464. Whereas SAS output is -463.

Re: excel round equation in sas

Tom — Thu, 17 Feb 2022 22:41:10 GMT

Did you check how both system handle rounding of negative numbers?

You could make you own test data to see.

If that does not provide an answer than check the individual pieces. If you are adding enough numbers the sum of small differences in each could result in values to slip from one side of the up/down dividing line for rounding.

topic Re: excel round equation in sas in SAS Programming

excel round equation in sas

Re: excel round equation in sas