topic Re: If condition for latest timestamp gives an output of 1 although the latest date are not equal in SAS Visual Analytics

If condition for latest timestamp gives an output of 1 although the latest date are not equal

Rian0126 — Mon, 20 Sep 2021 06:25:58 GMT

Hi,

I'm not sure if there is some bug. I'm getting a value of 1 (condition is TRUE) if "Max ETL Date" is equal to "Today CREATE_TIMESTAMP".

Although when I check the breakdown for latest "Max ETL Date" and latest "Today CREATE_TIMESTAMP", the values are different. Here are the screenshots:

1. Max ETL Date

2. Today CREATE_TMESTAMP

When I created the condition that if those two latest dates are equal, it should be 1 if not 0 under "Today 2" variable name:

"Today 2" variable is getting 1 row where "Max ETL Date" and "Today CREATE_TIMESTAMP" are equal. How come there is an instance of equal date if the dates I checked in item #s 1 and 2 above have different values?

Thank you.

Re: If condition for latest timestamp gives an output of 1 although the latest date are not equal

acordes — Tue, 21 Sep 2021 11:25:46 GMT

I think your today 2 variable needs a different aggregation.

Re: If condition for latest timestamp gives an output of 1 although the latest date are not equal

Rian0126 — Wed, 22 Sep 2021 01:01:06 GMT

I see. Thank you @acordes . I also used this method: https://communities.sas.com/t5/SAS-Communities-Library/Use-the-latest-date-in-your-VA-report/ta-p/536536.