Input function with hhmmss6. informat is behaving differently in SAS 9.2 and 9.3 when there are leading zeroes

Saugata — Mon, 07 Jul 2014 11:24:00 GMT

Hi,

I am executing the below code in both SAS 9.2 and 9.3:

data kk;

var='000042';

var2=input(var,hhmmss6.);

format var2 time8.;

run;

In SAS 9.2 (as well as in 9.1.3) the value of var2 is coming up as 0:00:42 (best12. value is 42), which is correct. But in 9.3 it is appearing as 42:00:00 (best12. value 151200). It seems SAS is just disregarding leading zeroes from the text field in 9.3.

Is there any change regarding this in SAS 9.3 for Input function (or informats).? I am really puzzled at why this correct thing be changed during upgrade, or is it a bug that crept in while moving on to 9.3.

I would really appreciate any insight on this.

Thanks & Regards,

Saugata Mukherjee.

Re: Input function with hhmmss6. informat is behaving differently in SAS 9.2 and 9.3 when there are leading zeroes

Kurt_Bremser — Mon, 07 Jul 2014 12:02:52 GMT

When the same code produces different results between SAS versions, and said difference is not noted somewhere in the documentation, it is clearly a matter for SAS tech support. Open a track there.

We had a similar problem in the behaviour of the $ebcdic format between 6.12/8.2 that lead to a fix.

topic Input function with hhmmss6. informat is behaving differently in SAS 9.2 and 9.3 when there are leading zeroes in SAS Programming

Input function with hhmmss6. informat is behaving differently in SAS 9.2 and 9.3 when there are leading zeroes

Re: Input function with hhmmss6. informat is behaving differently in SAS 9.2 and 9.3 when there are leading zeroes