Character date to numeric date

[Babloo]

Could you help me convert character date to numeric date? Code which I tried is

data dates;
	length mydate $ 10;
	input mydate $;
	datalines;
25.3.2016
;
run;

data dat (drop=mydate);
	set dates;
	mydates=input(mydate,ddmmyyp10.);
run;

Warning/Error:

36         	mydates=input(mydate,ddmmyyp10.);
                                 __________
                                 485
NOTE 485-185: Informat DDMMYYP was not found or could not be loaded.

37         run;

NOTE: Invalid argument to function INPUT at line 36 column 10.
mydate=25.3.2016 mydates=. _ERROR_=1 _N_=1

[PeterClemmensen]

Use ddmmyy10. informat like this

data test;
    mydate="25.3.2016";
    mydatenum=input(mydate, ddmmyy10.);

    format mydatenum ddmmyy10.;
run;

[Babloo]

I want date to displayed as 25.3.2016 and it should be numeric. But your code yields as 25/03/2016

Obs	mydate	mydatenum
1	25.3.2016	25/03/2016

[PeterClemmensen · Accepted solution]

Then do

data test;
    mydate="25.3.2016";
    mydatenum=input(mydate, ddmmyy10.);

    format mydatenum ddmmyyp10.;
run;

[Babloo]

perfect!

[Kurt_Bremser]

Once again: read the documentation!

There are no delimiter-specific informats, you only need to use ddmmyy10.