topic Re: Convert numeric time to SAS time in SAS Programming

Convert numeric time to SAS time

Ronein — Tue, 01 Feb 2022 08:47:42 GMT

Hello

I have a numeric value that represent time

for example 101600 is 10:16:00 (hour 10 ,mimutes 16,seconds 0)

How can I convert it into time variable please?

Re: Convert numeric time to SAS time

Kurt_Bremser — Tue, 01 Feb 2022 09:07:59 GMT

Use PUT() to create a string, CATX() to make it into a proper format for INPUT():

data _null_;
num = 101600;
length string $8;
string = put(num,z6.);
string = catx(":",substr(string,1,2),substr(string,3,2),substr(string,5,2));
time = input(string,time8.);
format time time8.;
put time=;
run;

Re: Convert numeric time to SAS time

ballardw — Tue, 01 Feb 2022 09:34:48 GMT

Or get the numeric parts of the value and use HMS function.

data junk;
   num = 101600;
   time = hms(int(num/10000),mod(int(num/100),100),mod(num,100)); 
   format time time8.;
run;

@Ronein wrote:

Hello

I have a numeric value that represent time

for example 101600 is 10:16:00 (hour 10 ,mimutes 16,seconds 0)

How can I convert it into time variable please?

Re: Convert numeric time to SAS time

FreelanceReinh — Tue, 01 Feb 2022 09:51:37 GMT

If it's a time of day (i.e., at most 235959), you can also use the B8601TM. informat:

time=input(put(num,z6.),b8601tm.);