02-04-2018 10:51 PM
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.
Length A $60.;
Please let me which Informat can read it properly.
02-05-2018 04:43 AM
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;
02-05-2018 06:35 PM
Need further help from the community? Please ask a new question.