topic Re: How can I convert the char to num for time because I need to calculate them in SAS Programming

How can I convert the char to num for time because I need to calculate them

SerenaJJ — Tue, 26 Mar 2024 20:10:15 GMT

Hi, I have time1: 2022-02-02T13:28

time2: 2022-02-02T12:28

They are both char vaules. Because I need to do the calculation if time1 > = time2 then

time3= time1 - time2 + 1, so how can I convert them to num value and then do the calculation.

Thank you.

Re: How can I convert the char to num for time because I need to calculate them

PaigeMiller — Tue, 26 Mar 2024 20:15:11 GMT

First, are you sure these are char? You need to find if the output from PROC CONTENTS says these are char. Sometimes you can't simply tell by looking at the values. Can you tell us what PROC CONTENTS says?

Re: How can I convert the char to num for time because I need to calculate them

Kurt_Bremser — Tue, 26 Mar 2024 20:19:36 GMT

Run a DATA step like this:

data want;
set have (rename=(time1=_time1 time2=_time2));
format time1 time2 e8601dt19.;
time1 = input(_time1,e8601dt16.);
time2 = input(_time2,e8601dt16.);
drop _time1 _time2;
run;

Untested, posted from my tablet.

Re: How can I convert the char to num for time because I need to calculate them

ballardw — Tue, 26 Mar 2024 22:38:12 GMT

You should show use exactly what you expect the result of time3= time1 - time2 + 1 would look like expressed as a time on the clock.

The values you show will most easily turn into a SAS datetime value which will have units of seconds.

So the Time3 value using the values shown would end up with a numeric value of 3601 which would represent 1:00:01 or one hour and 1 second.

If you want the number of HOURS you would would use something like

hours = intck('hour',time2,time1);

The INTCK function counts intervals. So could request seconds, hours, and since your values are DATETIME, could ask for day ('DTDAY' as the interval), month ('DTMONTH' as the interval) or a number of other intervals.

https://communities.sas.com/t5/SAS-Communities-Library/Working-with-Dates-and-Times-in-SAS-Tutorial/ta-p/424354 has a PDF with much information about dates.

Re: How can I convert the char to num for time because I need to calculate them

SerenaJJ — Wed, 27 Mar 2024 01:55:38 GMT

Thank you so much for your reply. I checked the output, there are days for the variable time3.

Re: How can I convert the char to num for time because I need to calculate them

SerenaJJ — Wed, 27 Mar 2024 02:44:51 GMT

Thank you so much for your reply. Yes, these are char after checking.

Re: How can I convert the char to num for time because I need to calculate them

Tom — Wed, 27 Mar 2024 03:20:49 GMT

If you want the difference in DAYS then convert the strings into DATE values. Those are stored in DAYS.

time3=input(time1,yymmdd10.)-input(time2,yymmdd10.)+1;

Re: How can I convert the char to num for time because I need to calculate them

SerenaJJ — Mon, 08 Apr 2024 19:07:25 GMT

Thank you all for your help!!

Re: How can I convert the char to num for time because I need to calculate them

SerenaJJ — Mon, 08 Apr 2024 19:07:47 GMT

Thank you so much!

Re: How can I convert the char to num for time because I need to calculate them

SerenaJJ — Mon, 08 Apr 2024 19:07:52 GMT

Thank you so much!