topic trouble reading datatime value from tab separated text file in SAS Programming

trouble reading datatime value from tab separated text file

csetzkorn — Wed, 21 Feb 2018 08:52:05 GMT

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!

Re: trouble reading datatime value from tab separated text file

Kurt_Bremser — Wed, 21 Feb 2018 11:08:21 GMT

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.

Re: trouble reading datatime value from tab separated text file

andreas_lds — Wed, 21 Feb 2018 11:16:57 GMT

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;