DATA Step, Macro, Functions and more

How to convert date9. to iso8601 format ?

Accepted Solution Solved
Reply
Contributor
Posts: 30
Accepted Solution

How to convert date9. to iso8601 format ?

Hi,

 

i want to convert below date and time to ISO8601 format

 

EXSTTM

EXSTDT

09:10

10-NOV-2015

09:20

16-NOV-2015

10:00

30-NOV-2015

.

12-DEC-2016

  EXSTTM : in cahrcter format $%

EXSTDT: IN DATE11. format

 

 

Want to below format

 

 

VARIABLE

10-11-2015T09:00

16-11-2015T09:20

30-11-2015T10:00

12-11-2016


Accepted Solutions
Solution
‎01-18-2017 03:48 AM
Super User
Posts: 6,938

Re: How to convert date9. to iso8601 format ?

[ Edited ]
data have;
infile cards dlm=',' dsd;
input exsttm :$5. exstdt :date11.;
format exstdt date11.;
cards;
09:10,10-NOV-2015
09:20,16-NOV-2015
10:00,30-NOV-2015
,12-DEC-2016
;
run;

data want;
set have;
if exsttm ne ' '
then do;
  hour = input(substr(exsttm,1,2),2.);
  minute = input(substr(exsttm,4,2),2.);
end;
else do;
  hour = 0;
  minute = 0;
end;
newdt = dhms(exstdt,hour,minute,0);
format newdt E8601DT19.;
run;

Note that the ISO 8601 standard always has yyyy-mm-dd, never dd-mm-yyyy in dates.

And there is no option to display SAS datetime values without seconds when using an e8601 format, AFAIK.

---------------------------------------------------------------------------------------------
Maxims of Maximally Efficient SAS Programmers

View solution in original post


All Replies
Solution
‎01-18-2017 03:48 AM
Super User
Posts: 6,938

Re: How to convert date9. to iso8601 format ?

[ Edited ]
data have;
infile cards dlm=',' dsd;
input exsttm :$5. exstdt :date11.;
format exstdt date11.;
cards;
09:10,10-NOV-2015
09:20,16-NOV-2015
10:00,30-NOV-2015
,12-DEC-2016
;
run;

data want;
set have;
if exsttm ne ' '
then do;
  hour = input(substr(exsttm,1,2),2.);
  minute = input(substr(exsttm,4,2),2.);
end;
else do;
  hour = 0;
  minute = 0;
end;
newdt = dhms(exstdt,hour,minute,0);
format newdt E8601DT19.;
run;

Note that the ISO 8601 standard always has yyyy-mm-dd, never dd-mm-yyyy in dates.

And there is no option to display SAS datetime values without seconds when using an e8601 format, AFAIK.

---------------------------------------------------------------------------------------------
Maxims of Maximally Efficient SAS Programmers
Contributor
Posts: 30

Re: How to convert date9. to iso8601 format ?

Thank you very much 

Spoiler
 
☑ This topic is SOLVED.

Need further help from the community? Please ask a new question.

Discussion stats
  • 2 replies
  • 193 views
  • 2 likes
  • 2 in conversation