- Mark as New
- Bookmark
- Subscribe
- Mute
- RSS Feed
- Permalink
- Report Inappropriate Content
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.
Accepted Solutions
- Mark as New
- Bookmark
- Subscribe
- Mute
- RSS Feed
- Permalink
- Report Inappropriate Content
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.
- Mark as New
- Bookmark
- Subscribe
- Mute
- RSS Feed
- Permalink
- Report Inappropriate Content
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.