Help using Base SAS procedures

Join DATE, HOURS, MINUTES and convert to ISO8601

Reply
Contributor
Posts: 34

Join DATE, HOURS, MINUTES and convert to ISO8601

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

Super User
Posts: 11,343

Re: Join DATE, HOURS, MINUTES and convert to ISO8601

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 :

Valued Guide
Posts: 2,177

Re: Join DATE, HOURS, MINUTES and convert to ISO8601

Ask a Question
Discussion stats
  • 2 replies
  • 218 views
  • 0 likes
  • 3 in conversation