I am reading a large 3GB csv file in sas. All variables are numeric except for one - DATE, which is a date in DD/MM/YYYY format. I use PROC IMPORT OUT= WORK.achat DATAFILE= "D:\products.csv" DBMS=DLM REPLACE; DELIMITER='3B'x; GETNAMES=YES; DATAROW=2; RUN; I noticed that some of the DATE values are missing in the SAS imported WORK.achat file (I can't open the source file = it's too big, but I am sure there is no missingness in the source). The log concerning this var reads informat DATE mmddyy10. ; Here's a piece of the error msg: NOTE: Invalid data for DATE in line 428723 50-59. RULE: ----+----1----+----2----+----3----+----4----+----5----+----6----+----7----+----8----+--- 428723 201601;7;02;201602019127800;2016020017134;2222222;17/01/2016;43;1;245;5400;1.0;1.03;13220 89 8;1;1.39;0.164;164.0;1000.0;100002 122 VAR1=201601VAR2=7 VAR3=2 VAR4=2.0160202 VAR5=2.01602 VAR6=2222222 DATE=. VAR7=43 VAR8=1 VAR9=245 VAR10=5400 VAR11=1 VAR12=1.03 VAR13=132208 VAR14=1 VAR15=1.39 VAR16=0.164 VAR17=164 VAR18=1000 VAR19=100002 _ERROR_=1 _N_=428722 I assume dates with day>12 were not recognized. Can someone please help me to enforce a ddmmyy format or change the default mmddyy10. when importing? Thank you very much.
... View more
