topic Re: ISO8601 to Numeric and back to ISO8601 in New SAS User

ISO8601 to Numeric and back to ISO8601

SASPhile — Thu, 09 Jan 2020 13:56:55 GMT

I'm having issues converting iso8601 date to numeric and back to iso8601. When converting back to iso8601, I'm getting extra 00's in the time component.

Ex: 2019-12-01T16:40 gets converted to numeric,.To reconvert it back I'm getting 2019-12-01T16:40:00

ANy help is apprecited.

Re: ISO8601 to Numeric and back to ISO8601

Kurt_Bremser — Thu, 09 Jan 2020 13:59:41 GMT

Just use proper format lengths:

data want;
input dt :e8601dt17.;
format dt e8601dt17.;
datalines;
2019-12-01T16:40
;

Re: ISO8601 to Numeric and back to ISO8601

SASPhile — Thu, 09 Jan 2020 14:06:23 GMT

THanks. what if the some dates have seconds like 2019-12-01T16:40:35 and some dont have 2019-12-01T16:40?

Re: ISO8601 to Numeric and back to ISO8601

Kurt_Bremser — Thu, 09 Jan 2020 14:11:27 GMT

Use the longer format.

2019-12-02T16:40 equals 2019-12-01T16:40:00 anyway, so there's no need to mask the seconds. The shorter format is only useful when seconds don't count.

Re: ISO8601 to Numeric and back to ISO8601

SASPhile — Thu, 09 Jan 2020 14:20:24 GMT

If the date doesnt have seconds ,I dont want to display seconds.

Re: ISO8601 to Numeric and back to ISO8601

Kurt_Bremser — Thu, 09 Jan 2020 14:27:40 GMT

Then you would need to create a custom format with an embedded function that uses the shorter format when there are no seconds (mod(value,60) = 0).

Or if you just need it in a report, conditionally format to a string first.

My VERY STRONG advice: don't do it, it's not worth the effort. If somebody complains, use a LART.

Re: ISO8601 to Numeric and back to ISO8601

Tom — Thu, 09 Jan 2020 14:33:14 GMT

@SASPhile wrote:

If the date doesnt have seconds ,I dont want to display seconds.

Then you need to store that information in another variable. The easiest way is to just keep the original text string. Or you could store the length of the original string.