topic Re: Character date to numeric date in SAS Programming

Character date to numeric date

Babloo — Wed, 25 Sep 2019 05:47:21 GMT

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

Re: Character date to numeric date

PeterClemmensen — Wed, 25 Sep 2019 06:04:36 GMT

Use ddmmyy10. informat like this


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

    format mydatenum ddmmyy10.;
run;

Re: Character date to numeric date

Kurt_Bremser — Wed, 25 Sep 2019 06:11:44 GMT

Once again: read the documentation!

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

Re: Character date to numeric date

Babloo — Wed, 25 Sep 2019 06:13:03 GMT

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

Re: Character date to numeric date

PeterClemmensen — Wed, 25 Sep 2019 06:14:30 GMT

Then do

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

    format mydatenum ddmmyyp10.;
run;

Re: Character date to numeric date

Babloo — Wed, 25 Sep 2019 06:16:53 GMT

perfect!