02-02-2014 09:41 PM
It would help knowing what generated that number, or better, what date it represents, as it does not look like the number behind a SAS date or a SAS datetime.
02-03-2014 03:25 AM
In Excel this would correspond to a date in the year 5000, and in SAS sixty years later. It does not make much sense to interpret it as a datetime value because that gives a SAS date in January 1960. My guess is your data is corrupted and might possibly represent 11/13/12 in US style.
02-03-2014 09:10 AM
We sometimes get dates like this from COBOL programs (because of lazy programmers at Y2K). The first digit is sometimes the "century", so a "1" is 2000 and a blank is "1900". Therefore your date is 2013 11 20.
The way we convert the date is to add 19000000 to the number and that give you a meaningful date value.
then read as YYYYMMDD