08-16-2013 10:49 AM
I'm trying to import a txt file with 3 datetime fields. The fields are ddmmyyyy hh:mm:ss and I can't find the informat corresponding to this one. I've tried with anydt but doesn't work.
Some fields are imported missing and many others wrong. For example 01/12/2012 09:24:54 is imported as 12Jan12 when it should be 1Dec...
thanks in advance.
08-16-2013 11:03 AM
If anydt does read the value but fails to properly distinguish months from days, it likely has to do with your
option. However, anydt. may or may not work with all datetime informats. Try
before your data step and see if it fixes your issue.
08-16-2013 11:08 AM
input v1 anydtdtm.;
put v1 datetime18.;
output to log is
So it should solve your problem.
08-16-2013 11:38 AM
Hrm I'm not too familiar with what all options can be played directly with EG interface but here's an alternative that should allow you to only set the option and use the import interface as you did before
options ->custom code->insert custom sas code before task and query code (Check) -> edit...
type in a single line
Save and then run whatever you were running.