topic Re: Calculate diffrence between two DateTime fields in SAS VA in SAS Visual Analytics

Calculate diffrence between two DateTime fields in SAS VA

Saurabh77 — Fri, 30 Aug 2019 12:52:32 GMT

Hello All

I have two dates in following format

Date 1 - December 11, 2018 05:15:20PM

Date 2 - January 21, 2018 01:25:21AM

How can i calculate difference between these two date in HOURS ?

Thanks in Advance

Re: Calculate diffrence between two DateTime fields in SAS VA

novinosrin — Fri, 30 Aug 2019 13:07:15 GMT


data test;
char_Date1='December 11, 2018 05:15:20PM';
Num_date1=input(char_Date1,anydtdtm32.);
char_Date2='January 21, 2018 01:25:21AM';
Num_date2=input(char_Date2,anydtdtm32.);
Difference=abs(intck('DTHOUR',Num_date1,Num_date2));
format num_date: datetime20.;
run;

Re: Calculate diffrence between two DateTime fields in SAS VA

Saurabh77 — Fri, 30 Aug 2019 13:13:00 GMT

Hello Novinosrin

Thanks for the reply..What i am asking is simple function in SAS Visual Analytics to get the output.

This programe cannot possible to write in SAS VA

Re: Calculate diffrence between two DateTime fields in SAS VA

novinosrin — Fri, 30 Aug 2019 13:16:47 GMT

Oh I blame the damn!!!!!!!!!!!!!!!!! Dunkin Coffee(still not waking me up) that my eyes didn't even notice the VA in the question. My apologies. Best is to wait for somebody who knows VA to respond. Sorry about that.

Re: Calculate diffrence between two DateTime fields in SAS VA

JanSanford — Thu, 22 Apr 2021 14:23:02 GMT

I am having the same issue but my datetime fields are formatted as 07OCT2018:10:14:00.00. Can you provide a solution for me?

Re: Calculate diffrence between two DateTime fields in SAS VA

novinosrin — Thu, 22 Apr 2021 14:41:44 GMT

Hi @JanSanford I'm afraid I do not work with SAS VA. Are you expecting a solution in SAS VA?

Re: Calculate diffrence between two DateTime fields in SAS VA

JanSanford — Thu, 22 Apr 2021 14:59:18 GMT

Oops. No. Am using base SAS.

Re: Calculate diffrence between two DateTime fields in SAS VA

SASKiwi — Thu, 22 Apr 2021 20:22:14 GMT

Datetimes are stored as seconds. You could just subtract one from the other then divide by 3,600 to convert to hours.