topic Re: Strange with format e8601dt in SAS Programming

Strange with format e8601dt

sasmilly — Thu, 17 Mar 2016 04:09:58 GMT

when I run code1 and code 2, different values got for variable num2_1. Anyone can help to explain why? I use SAS EG Version 5.1

Code1

data test;

var1 = '2015-01-01';

var2 = '2015-01-01T10:00';

if length(var1)=10 then num1 = input(strip(var1)||'T10:00',e8601dt.);

num2_1 = input(strip(var2),e8601dt.);

num2_2 = input(var2,e8601dt.);

run;

Code 2

data test;

var1 = '2015-01-01';

var2 = '2015-01-01T10:00';

/*if length(var1)=10 then num1 = input(strip(var1)||'T10:00',e8601dt.);*/

num2_1 = input(strip(var2),e8601dt.);

num2_2 = input(var2,e8601dt.);

run;

Re: Strange with format e8601dt

Kurt_Bremser — Thu, 17 Mar 2016 07:06:07 GMT

Also happens here with SAS 9.2 on AIX. Contact SAS Technical Support.

The if length(var1) = 10 is irrelevant. Just doing the num1= with using the format causes the next expression to return a missing value. I positively think this is a bug with the format (or format handling routine).

PS Which SAS version is behind your EG 5.1?

Re: Strange with format e8601dt

sasmilly — Thu, 17 Mar 2016 07:39:41 GMT

Thanks for your reply. SAS 9.3

Re: Strange with format e8601dt

Kurt_Bremser — Thu, 17 Mar 2016 07:57:24 GMT

These formats were introduced with 9.2, so it is not that surprising that there are some yet undiscovered bugs that show themselves in certain peculiar situations.

Re: Strange with format e8601dt

FreelanceReinh — Thu, 17 Mar 2016 12:58:41 GMT

This is really strange. But with SAS 9.4 (TS1M2) I cannot replicate the issue.

Re: Strange with format e8601dt

Oligolas — Thu, 17 Mar 2016 13:49:36 GMT

Neither can I

SAS 9.4 (TS1M2 32-bit)

SAS EG 7.1 HF1 (32-bit)

Re: Strange with format e8601dt

Kurt_Bremser — Thu, 17 Mar 2016 13:51:51 GMT

Looks like a bug that was introduced in 9.2 (when those formats were added) and weeded out with 9.4.

Re: Strange with format e8601dt

sasmilly — Wed, 23 Mar 2016 05:19:18 GMT

Thanks!