topic Re: convert sas numeric time into sas time in SAS Programming

convert sas numeric time into sas time

Ronein — Thu, 25 Aug 2022 05:21:17 GMT

Hello

Someone sent me a data set that contain a column called time.

This column is numeric type ( no sas time/date) and have values of time .

For example:

value 145000 means hour:14 minutes: 50 second:00 ( so the format is HH:MM:SS).

What is the way to convert it into SAS time format?

Data have;
input time;
cards;
112800
145000
84800
204500
132500
130400
110800
123000
123400
90600
115600
101600
100800
73500
143000
104200
95900
100500
90300
120100
212900
104600
112700
153200
140300
24900
114000
160600
123800
101900
100800
202900
110500
75900
130000
231200
;
Run;

Re: convert sas numeric time into sas time

Kurt_Bremser — Thu, 25 Aug 2022 07:30:56 GMT

Create a PICTURE format which adds the colons:

proc format;
picture colons
  low-high = '00:00:00'
;
run,

then use it in a PUT/INPUT:

data want;
set have;
time = input(put(time,colons8.),time8.);
format time time8.;
run;

Untested, posted from my tablet.

Edit: after testing, changed the length of the COLONS format to 8 in the PUT function.

Re: convert sas numeric time into sas time

FreelanceReinh — Thu, 25 Aug 2022 08:23:54 GMT

Alternatively, you can use the SAS-supplied Z6. format (to add the missing leading zero to values such as 84800) and B8601TM. informat:

time=input(put(time,z6.),b8601tm.);
format time time8.;

Re: convert sas numeric time into sas time

Kurt_Bremser — Thu, 25 Aug 2022 09:44:59 GMT

Perfect!

Re: convert sas numeric time into sas time

Ksharp — Thu, 25 Aug 2022 11:44:13 GMT

Data have;
input time;
want=hms(int(time/10000),int(mod(time,10000)/100),mod(time,100));
format want tod8.;
cards;
112800
145000
84800
204500
132500
130400
110800
123000
123400
90600
115600
101600
100800
73500
143000
104200
95900
100500
90300
120100
212900
104600
112700
153200
140300
24900
114000
160600
123800
101900
100800
202900
110500
75900
130000
231200
;
Run;