I'm trying to import CSV file with dates . Looks like when I do that some dates are not read correctly in SAS. I suspect the reason is that some of the dates within csv are in a format e.g text that SAS cannot convert correctly to a sas date. To remedy this, i have read a document somewhere that using the following expression when importing: Libname.. Mixed=yes stringdates=yes scantime=yes; and then adding a statement like this data sheet29 ( drop= datevar) format datevar date9.; set .......(rename=(datevar=_datevar))) _datevar=input ( datevar, mmdyy10.); run; Libname .... clear The problem is how do i integrate this statement with my proc import, which looks like this: PROC IMPORT OUT= WORK..... DATAFILE= "C..... DBMS=..... REPLACE; ............... GETNAMES=YES; run: Thanks.
... View more