topic Re: SAS Viya Calculation Bug: 1+6=8? in SAS Visual Analytics

SAS Viya Calculation Bug: 1+6=8?

Naiii — Thu, 03 Oct 2024 12:22:19 GMT

Please, has anyone already noticed that SAS Viya makes calculation errors? For example, it calculates the total of 1+6 as 8. Any solutions, please?

Re: SAS Viya Calculation Bug: 1+6=8?

JuanS_OCS — Thu, 03 Oct 2024 12:42:28 GMT

Hello @Naiii ,

I personally would like to ask you to provide some evidence, specially when you raise such question or statement.

It would help us understand.

For example, the "error" you indicate, could be well a rounding up/down typical issue on the generation/definition of your report, which you could find in other applications, any, really. To give you a quick example, when the data is behind what is shown is 1.65 (just stripping all decimals or the cell is not large enough) and 6, the cells might show 1 and 6 but rounding up the total is 8 (when round up in totals/aggregation).

Looking forward to hearing back from you.

Re: SAS Viya Calculation Bug: 1+6=8?

Sam_SAS — Thu, 03 Oct 2024 13:09:32 GMT

Often what confuses people is that most visualizations display aggregated data, but calculations are evaluated at the row level. If you create a list table with "detail data" enabled, the values should look correct. Especially if you set the data format to display more decimal places.

Let us know if that helps to clear things up.

Sam

Re: SAS Viya Calculation Bug: 1+6=8?

ballardw — Thu, 03 Oct 2024 15:18:57 GMT

Open your favorite speadsheet software.

Assign numeric display of a column to show no decimals.

Enter 1.45 in the first row

Enter 6.45 in the second row

Sum the two on row three in the same column.

Because you set the display limit to exclude decimals the cells will show 1, 6 and 8. The 8 is because the display rounded the actual summed value of 7.9 up to 8. Also why I picked values with .45 as the decimal portion as each of those gets rounded down.

So not just a SAS Viya behavior. This has been around for a very long time actually predating computers: when to round in calculations.

Re: SAS Viya Calculation Bug: 1+6=8?

Patrick — Fri, 04 Oct 2024 03:29:35 GMT

Just to add what already has been said.

data demo;
  a=10/3;
  b=10/3;
  c=10/3;
  total=sum(a,b,c);
run;

proc print data=demo;
  format _numeric_ f16.1;
run;

Re: SAS Viya Calculation Bug: 1+6=8?

Naiii — Fri, 04 Oct 2024 08:44:39 GMT

The numbers do not contain decimals

In that case, it sets total = 7.

Re: SAS Viya Calculation Bug: 1+6=8?

JuanS_OCS — Fri, 04 Oct 2024 10:13:30 GMT

Hi @Naiii ,

yours is a visual representation. Any tool that does visual reporting has sometimes the challenge of visual representation vs data, in terms of decimals and aggregations.

I can observe you presented us with your visual representation in 2 separate screenshots, which tells me there i still more to this story. Either in the formulas or your data behind the scenes, and both need to be further understood.

If you still have doubts, I would strongly suggest to open a ticket with SAS Technical Support to analyze your report & data.

To answer your initial question, directly: I work with many clients and SAS deployments (Viya and not Viya), and while, as discussed above, you may experience these discrepancies in the visualization (as you can see in any other visualization tool), I have never seen this kind of issue with the data+calculations.

The responsibility of the visualization lays on the shoulders of the author of the report, except on very rare cases where there might a software defect, which I doubt very much is the case. Yet, if you want to challenge this aspect, SAS Technical Support will help you figure it out.

Re: SAS Viya Calculation Bug: 1+6=8?

ballardw — Fri, 04 Oct 2024 14:05:08 GMT

@Naiii wrote:

The numbers do not contain decimals

In that case, it sets total = 7.

Pictures are not data, or very good proof of what values may be involved. Especially with what appears to be a very heavily edited picture.

Re: SAS Viya Calculation Bug: 1+6=8?

Stu_SAS — Mon, 07 Oct 2024 17:29:04 GMT

Can you change its format to Float12.2, then post a screenshot of the results? Visual Analytics uses the BEST12. format by default which may not necessarily include decimals.