topic Re: character date, expressed 30.02.2002, how to change to numeric in SAS Procedures

character date, expressed 30.02.2002, how to change to numeric

cookvyz — Sun, 31 May 2015 10:14:29 GMT

Hi All,

I have a variable with dates listed in a format of 30.03.2002.

I have tried many options without success.

Here are some commands I have worked with:

new date=input(olddate,date9.);

newdate=input(compress(olddate,'.'),date9.);

newdate= INPUT(compress(olddate),date9.);

format newdate date9.;

Any help would be very much appreciated.

Kind Regards,

Karen

Re: character date, expressed 30.02.2002, how to change to numeric

PGStats — Mon, 01 Jun 2015 01:37:29 GMT

Use format anydtdte :

data test;

dateStr = "30.03.2002";

date = input(dateStr, anydtdte10.);

output;

dateStr = "04.03.2002";

date = input(dateStr, anydtdte10.);

output;

format date date9.;

run;

proc print; run;

Re: character date, expressed 30.02.2002, how to change to numeric

Kurt_Bremser — Mon, 01 Jun 2015 06:15:08 GMT

To force a correct format, I would avoid the anydtdte10. format, as it may convert some values in an unexpected fashion (03/02/2002: March 2nd or February 3rd?).

Instead use

newdate = input(olddate,ddmmyy10.);