topic Re: Time Conversion in SAS Studio

Time Conversion

gnrslasher37 — Tue, 26 Jul 2016 03:18:43 GMT

hi,

i have numeric data in hundreths place like

250

103

356

which i want to convert it in the Time format of hhmm.

Thanks.

RahulG — Tue, 26 Jul 2016 03:34:45 GMT

What is your desired output.

do you want to see your data as mentioned below

02:50

01:03

03:56

Tom — Tue, 26 Jul 2016 04:00:01 GMT

You could just use some arithmetic and the HMS() function.

time=hms(int(number/100),mod(number,100),0);

Or you could add some leading and trailing zeros to make it look like HHMMSS string and use the INPUT() function.

time=input(put(100*number,z6.),B8601TM6.);