Hi all, I am currently trying to import a CSV file and keep getting the below Note; NOTE: Invalid data for STARTDATE in line 2 444-462. I know that this is being caused due to the data which is trying to be read in is 22/07/2018 09:56:20 in the UK format of dd/mm/yyyy hh:mm:ss but I cannot seem to find the right informat to properly read the data. I have tried DATE, DATETIME, ANDTTME, even E8601DX (all with a width of 16) but nothing seems to work. I am using a data step and defining lengths, formats, informats etc., and I am also using SAS EG 7.15 (7.100.5.5850) (64-bit) to access a LINUX server running 9.4. Any help would be greatly appreciated.
... View more