topic Conversion of ISO8601 date format to Hour format in SAS Programming

Conversion of ISO8601 date format to Hour format

Daya87 — Tue, 06 Jun 2017 07:13:28 GMT

Hi All,

I want to Convert the date/time from ISO8601 format to hour Format Please help on this. I have data like

name Date1 Date2

XYZ 2016-10-03T13:05 2016-09-26T12:35
ABC 2016-07-15T12:00 2016-10-18T11:30

BAC 2016-10-26T12:00 2016-08-10T10:45

CAB 2017-06-02 2016-09-26T11:30

BDG 2016-06-23T14:00 2016-10-18T09:28

I require the output in two variables Hour1 and Hour2

Thanks in advance

Regards

Daya

Re: Conversion of ISO8601 date format to Hour format

BrunoMueller — Tue, 06 Jun 2017 07:43:46 GMT

Have a look at the E8601DT informat, it will read char values as you show them below and convert it to a SAS Datetime value. You can use then the TIMEPART() function to only the time information.

Re: Conversion of ISO8601 date format to Hour format

Kurt_Bremser — Tue, 06 Jun 2017 12:33:34 GMT

Do a google search for "sas iso 8601 informat", and you'll have all the information you need. And much more.