topic Re: Join DATE, HOURS, MINUTES and convert to ISO8601 in SAS Procedures

Join DATE, HOURS, MINUTES and convert to ISO8601

Almighty — Mon, 25 Aug 2014 19:37:57 GMT

Hi Gurus,

I am having a difficulty in combing numeric date with character time. Then finally convert to Iso8601 format.

Data have:

Output Needed:

Appreciate your help and time.

Thanks

ballardw — Mon, 25 Aug 2014 20:34:15 GMT

Assuming your data is a SAS date

Date_needed= dhms(date,input(hours,f2.),input(minutes,f2.), 0);

format date_needed b8601dt13.0;

I'm not sure that ISO8601 allows - and :

Peter_C — Mon, 25 Aug 2014 21:37:15 GMT

Try format E8601dt.

See doc at