Hi, I have a same question with dates. I have a character value for date of birth  which is 36223 and I want to convert it to any date format either date9 or yymmdd or mmddyy. My excel shows that date as 3/5/1999 but when I converted to sas date using date9 or any other formats it gives me 3/4/2059 which is very weird.   This is my program that I wrote to convert it to sas date format   data have; set new; birthdate=input(dob, yymmdd10.); format birthdate date9.; run;   I'm getting many missing values for other DOBs but some date of births that I get are not correct. As I mentioned above the character value of 36223 comes as 3/4/2059 after applying the format. Any help is greatly appreciated.   thanks M     ... View more