Yes while importing the file I changed the source_informat to anydtdtew. and it resolved the issue. Still not sure how it did . data a; input date1 anydtdte.; datalines; 1/31/2011 4:42:40 AM ; run; proc sql; select date1 as date2 format date9. from a where date1 eq "31jan2011"D; quit;
... View more
