Character date 31.03.2001 to numerical, SAS -

i have variable entered 31.01.2002 entries, , character. put in numerical form date9. .

i have tried below:

date=input(oldway, 10.);  date=input(oldway, date9.); put date=ddmmyy10.;  date=input(compress(oldway,'.'),10.);  date = input(compress(oldway),date9.);  format date date9.; run; 

i have tried combinations of above , no avail.

any ideas forward motion?

kind regards!!

you can't input date using date9. informat string variable isn't in format. can use ddmmyy10., though, , takes care of . characters.

data have; input old $10.; cards; 31.01.2014 28.02.2014 01.01.2015 ; run;  data want; set have; new = input(old, ddmmyy10.); format new date9.; run;