Join DATE, HOURS, MINUTES and convert to ISO8601

[Almighty]

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]

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]

Try format E8601dt.

See doc at

http://support.sas.com/documentation/cdl/en/lrdict/64316/HTML/default/viewer.htm#a003169814.htm