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

[myleha]

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!

[JosvanderVelden · Accepted solution]

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

Have a look at the example below:

[myleha]

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!

[SASKiwi]

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.