trouble reading datatime value from tab separated text file

[csetzkorn]

I am using this code, which was originally generated in terms of the data formats using an import task:

DATA Bla;
    LENGTH
        Timestamp          8 ;
    FORMAT
        Timestamp        DATETIME18. ;
    INFORMAT
        Timestamp        DATETIME18. ;
    INFILE "&BaseFolder.&FileName2."
	        ENCODING="LATIN9"
	        TERMSTR=CRLF
	        DLM='09'x
	        MISSOVER
	        DSD 
			firstobs=2;
    INPUT
        Timestamp        : ?? ANYDTDTM19. ;
RUN;

Unfortunately, I now get errors  and funny entries like this:

 ******************

for source data like this:

31/05/2016 00:00:00

Can someone please advice how to potentially adjust the above formats? Thanks!

[Kurt_Bremser]

I'd read it into a character variable, convert the date and time parts separately (substr() and input() functions), and put together with result = date * 86400 + time.

[andreas_lds · Accepted solution]

No problem, when using anydtdtm. instead of anydtdtm19.:

data work.forum;
   a = '31/05/2016 00:00:00';
   b = input(a, anydtdtm.);

   format b DATETIME18.;
run;