Hey @FreelanceReinh, I managed to get the output if I use: informat PostDate YMDDTTM32.;   But the format PostDate Date16. will not work. But I still managed to read the date in...  I guess perhaps the informat is wrong in the first place...   Sorry to waste your time! ... View more

Hmm, I tried using only 2 lines of the data:   PostDate|CardID|CardType|OpenDate 2015-09-30 00:00|1311364|0|2015-01-04 00:00 2015-09-30 00:00|959623|0|2010-05-06 00:00   And using the codes: data want; %let _EFIERR_ = 0; /* set the ERROR detection macro variable */ infile 'FILE PATH' delimiter = '|' MISSOVER DSD lrecl=32767 firstobs=2 ; informat PostDate ANYDTDTE. ; informat CardID best32. ; informat CardType best32. ; informat OpenDate ANYDTDTM32. ; format PostDate DATE9. ; format CardID best12. ; format CardType best12. ; format OpenDate DATETIME16. ; input PostDate CardID CardType OpenDate ; if _ERROR_ then call symput('_EFIERR_',1); /* set ERROR detection macro variable */ run; The message in the log: NOTE: Numeric values have been converted to character values at the places given by: (Line):(Column). 3316:40 NOTE: The infile 'FILE PATH' is: File Name=FILE PATH, RECFM=V,LRECL=32767 NOTE: 2 records were read from the infile 'FILE PATH'. The minimum record length was 42. The maximum record length was 43. NOTE: The data set WANT has 2 observations and 4 variables. NOTE: DATA statement used (Total process time): real time 0.02 seconds cpu time 0.01 seconds ... View more

Ooh, I have changed it. But all my dates are still missing... The OpenDate is the same format as my PostDate. So I don't think there should be any problem right? ... View more