topic How to calculate difference (in hours) between 2 datetime items? in SAS Visual Analytics

How to calculate difference (in hours) between 2 datetime items?

myleha — Fri, 12 Mar 2021 08:58:57 GMT

Hi all,

I'm a new SAS VA user. I'm using SAS VA 8.5.

I need to calculate the difference in hours between 2 datetime items. Particularly, to calculate "How many hours does it take between Lstupdt_Timestamp and Create_Timestamp?"

I tried to use TreatAs(Hour) but it didn't work. The result was incorrect (screenshots below).

I switched to TimePart but the result wasn't correct, either:

I don't know what went wrong. Any help would be much appreciated.

Thank you!

Re: How to calculate difference (in hours) between 2 datetime items?

JosvanderVelden — Fri, 12 Mar 2021 15:26:58 GMT

Have a look at this FAQ page: https://communities.sas.com/t5/SAS-Communities-Library/3-FAQs-on-date-calculations-in-SAS-Visual-Analytics/ta-p/251260

Have a look at the example below:

Re: How to calculate difference (in hours) between 2 datetime items?

SASKiwi — Sat, 13 Mar 2021 22:32:26 GMT

If you want to do this row by row from columns that are in your VA load table then you could calculate the difference in a new column in your source table before you load it into VA.

Re: How to calculate difference (in hours) between 2 datetime items?

myleha — Mon, 15 Mar 2021 02:45:02 GMT

Thank you so much! I did a bit of transformation with the data, and changed the format to HOURS like you showed and it worked!