topic Re: Convert HHMM (character format) into HH:MM format in SAS Programming

Convert HHMM (character format) into HH:MM format

ppchennn — Thu, 07 Sep 2017 09:33:21 GMT

So I have a column that looks like this:

data time;

input  time $4.;

datalines;
0930
1000
0800
1300
1530
;
run;

and I want it to look like this:

09:30

10:00

08:00

13:00

15:30

Which is in a HHMM. or TIME. format

Tried the PUT statement and came back with an error

ERROR: The informat HHMM was not found or could not be loaded.

Is there any simple ways of doing this?

Thanks.

Re: Convert HHMM (character format) into HH:MM format

andreas_lds — Thu, 07 Sep 2017 09:56:59 GMT

Maybe i am blind, but i don't see the mentioned put statement in your code.

Index of informats: https://support.sas.com/documentation/cdl/en/leforinforref/64790/HTML/default/viewer.htm#n0verk17pchh4vn1akrrv0b5w3r0.htm

I suggest using "hhmmss" instead of "hhmm".

Re: Convert HHMM (character format) into HH:MM format

RW9 — Thu, 07 Sep 2017 09:57:19 GMT

data time;
  input time $4.;
  time_calc=input(time,hhmmss4.);
  format time_calc time5.;
datalines;
0930
1000
0800
1300
1530
;
run;

Re: Convert HHMM (character format) into HH:MM format

RahulG — Thu, 07 Sep 2017 10:00:51 GMT

I could not find relevant format to read it direclty. But you can use below code to get desired result.

data time(keep=t1 time);

input  time $4.;
t1=substr(time,1,2)*3600 +substr(time,3,2)*60 ;
format t1 time5.;
datalines;
0930
1000
0800
1300
1530
;
run;

Re: Convert HHMM (character format) into HH:MM format

ppchennn — Fri, 08 Sep 2017 01:44:56 GMT

Sorry I failed to include that in my post! So I guess using hhmmss instead of hhmm is because SAS calculates time based on seconds?

Re: Convert HHMM (character format) into HH:MM format

ppchennn — Fri, 08 Sep 2017 01:47:02 GMT

Thanks a lot! Now I know what I'm doing wrong.