topic Re: Wrong calculation when calculating difference between dates using Now () in Viya in SAS Visual Analytics

Wrong calculation when calculating difference between dates using Now () in Viya

dmen24 — Wed, 24 Jul 2024 17:02:44 GMT

I need to calculate the number of days between today's date (Now operator) and another date (DOI).

I applied Treatas to the DOI and Treatas and DatePart for Now. I created a variable (FLAG - Past year) based on subracting DOI from Now to get the number of days in between.

Then these are the results. You will see the NOW variable in the list table has different values. It should be the same value.

The FLAG - Past year (1) is the number of days between Now and DOI. The values are incorrect.

What's going wrong? Suggestions please.

Re: Wrong calculation when calculating difference between dates using Now () in Viya

TSBruce — Wed, 24 Jul 2024 17:14:23 GMT

I suspect your numeric measures are being aggregated in the table. You may try setting the option on the table to display detail data so these values are not aggregated. I am not sure what your end goal is here, but you could also change the aggregation type for NOW to be AVG instead of SUM and that should give you what you expect if the values are being aggregated.

Re: Wrong calculation when calculating difference between dates using Now () in Viya

Sam_SAS — Wed, 24 Jul 2024 17:20:06 GMT

Hello,

I tried to duplicate your issue and I got REALLY confused... until I realized that I was seeing aggregated values! 🙂

In the options for your list table, enable "Detail data" and your numbers should make sense again.

(ETA: +1 to what @TSBruce said)

Let us know if that helps,

Sam

Re: Wrong calculation when calculating difference between dates using Now () in Viya

dmen24 — Wed, 24 Jul 2024 17:24:42 GMT

It worked! Thanks.

Re: Wrong calculation when calculating difference between dates using Now () in Viya

dmen24 — Wed, 24 Jul 2024 17:25:14 GMT

That was it! Thanks.