In SAS 9.2, when i read a text file using proc import to bring as a SAS dataset, one of the column which had date value [2015/08/13:12:00:00 AM] used to be imported as character format and the date value remained the same [2015/08/13:12:00:00 AM].
Now, in SAS 9.4 when i use the same proc import to import the same text file to SAS dataset, the column with the value [2015/08/13:12:00:00 AM] comes in as a date format with the value changed to 13AUG15:00:00:00. We just moved from 9.2 to 9.4.
Here is the code that was working for me in 9.2.
proc import datafile="C:\Desktop\Sample.txt"
out=test12
dbms=dlm
replace;
delimiter=',';
datarow=2;
run;
I tried to use the option usedate=no but SAS throws me an error.
... View more