Thanks a lot for answering I have used the ANYDTDTE informate but it seems it only work on your code but not mine. At last I used the method of reading in the date variable as a character variable and converting it into a SAS date. I modified a little that I used : length chardat $ 10 default=7; infile"the csv file"; input chardate; if length(chardate) ne 10 then date=input(chardate,date7.); else date=input(chardate,ddmmyy10.);
... View more