topic How to read yyyymmddhmmss informat in SAS Programming

How to read yyyymmddhmmss informat

Riteshdell — Mon, 05 Feb 2018 03:51:48 GMT

Hello Expert,

Could you Please help me to read yyyymmddhmmss date value.

I have a character column which is containing records in yyyymmddhmmss format.

Please help me to read values.

Data Test;

Length A $60.;

A='20180205092045';

B=input(A,informat);

run;

Please let me which Informat can read it properly.

Regards,

Ritesh

Re: How to read yyyymmddhmmss informat

AndrewHowell — Mon, 05 Feb 2018 04:07:27 GMT

Data Test;

    Length A $60.;

    A='20180205092045';

    B=input(A,anydtdtm.);

run;

Re: How to read yyyymmddhmmss informat

Riteshdell — Mon, 05 Feb 2018 04:10:17 GMT

its not reading in anydtdtm. informat.
I want my data in datetime20.6 format.

Re: How to read yyyymmddhmmss informat

kiranv_ — Mon, 05 Feb 2018 05:12:59 GMT

something like

Data Test;
    A='20180205092045';
    B=input(A, B8601DJ16.);
    format B datetime20.;
run;

Re: How to read yyyymmddhmmss informat

srinath3111 — Mon, 05 Feb 2018 07:16:12 GMT

Data Test;

Length A $60.;

A='20180205092045';

B=input(A,anydtdte14.);

run;

Re: How to read yyyymmddhmmss informat

Kurt_Bremser — Mon, 05 Feb 2018 09:43:42 GMT

I strongly advise against the use of the "any" informats. You just tell SAS to make a guess and create something out of a string that could contain absolute crap, and still end up with a non-missing value (and not even a NOTE!) that later wrecks all your analysis.

Force correct data at every step of your analytic chain, and never let the computer do your thinking for you. See Maxims 31 and 22.

Follow @kiranv_'s suggestion for using one of the ISO 8601 formats. I'd even use one for display:

Data Test;
    A='20180205092045';
    B=input(A, B8601DJ16.);
    format B e8601dt19.;
run;

Re: How to read yyyymmddhmmss informat

AndrewHowell — Mon, 05 Feb 2018 23:35:39 GMT

I wouldn't advocate the "any" informats in a critical operational environment. But the need which created the "any" informat highlights that there are inputs where we cannot mandate a consistent date/datetime informat. (That may or may not be the case here.)
Any use of an "any" informat MUST come with the presumption that the date might be incorrectly informatted.

Re: How to read yyyymmddhmmss informat

Riteshdell — Thu, 08 Feb 2018 11:40:22 GMT

Thanks Its working