Hi all!! I have a problem with loading some data because of the date-time format. Data comes like this: 2015-03-31T12:15:17.142412000+11 that is, yyyy-mm-ddThh:mm:ss.fffffffff+hh which in SAS 9.4 (the one i'm using) would be "E8601DZw.d". However, it doesn't load correctly, so I started searching for a solution and looking in the SAS documentation E8601DZw.d Informat, I found it explicitly says: "Restriction: The shorter form +|–hh is not supported.", which unfortunately is mine. Thus, what can I do? Is there any other way to read my format in this version of SAS? Also it is important to know that the data file is a 80GB csv file, so, it takes a while to read it. Thank you!!! My code (edited): data WORK.tnq ;
infile 'C:\Folder\Test.csv' delimiter = ',' MISSOVER DSD lrecl=32767 firstobs=2 ;
informat Date_Time E8601DZ32.6 ;
format Date_Time E8601DZ32.6 ;
input Date_Time $;
* Splitting Date and Time;
Date = datepart(Date_Time);
Time = timepart(Date_Time);
informat Date E8601DA10. ;
informat Time E8601TM15.6 ;
format Date E8601DA10. ;
format Time E8601TM15.6 ;
if _ERROR_ then call symputx('_EFIERR_',1);
month = month(date) + (year(date)*12) - 24164;
run;
... View more