topic How to convert numeric date to sasdate ? in SAS Procedures

How to convert numeric date to sasdate ?

sasbasls — Thu, 05 Jan 2012 19:44:58 GMT

I have a variable in a dataset with value like "ccyy-mm-dd" as character. How can I convert to date ?

I have used input(date,yymmdd10.);, but using this I am still getting variable type as character with a value like a numeric number, not date value. Please advise.

thanks in advance!

How to convert numeric date to sasdate ?

art297 — Thu, 05 Jan 2012 19:50:59 GMT

Not sure why you are running into a problem. The following works for me:

data have;

input date $10.;

cards;

2011-01-01

2011-01-02

;

data want (drop=_:);

format date date9.;

set have (rename=(date=_date));

date=input(_date,yymmdd10.);

run;

How to convert numeric date to sasdate ?

sasbasls — Thu, 05 Jan 2012 20:07:31 GMT

Thanks for quick response. I am getting error "Variable mydate has been defined as both character and numeric"

I have variable "mydate" in a dataset, I am not passing inline data using cards statement.

But when I did proc datasets on my dataset, I see variable as character type with length as 30. Any insight what's wrong I am doing in here ?

Re: How to convert numeric date to sasdate ?

art297 — Thu, 05 Jan 2012 20:10:58 GMT

Same as my example. You can't change a variable from character to numeric, but you can rename it and create a new variable with the old variable name, and drop the old variable. So, using the same example, assuming your current data are in a SAS dataset called have:

data want (drop=_:);

format date date9.;

set have (rename=(mydate=_mydate));

date=input(_mydate,yymmdd10.);

run;

Re: How to convert numeric date to sasdate ?

Linlin — Thu, 05 Jan 2012 20:45:21 GMT

data have;

input mydate $10.;

cards;

2011-01-01

2011-01-02

;

data want (drop=_:);

format mydate date9.;

set have (rename=(mydate=_mydate));

mydate=input(_mydate,yymmdd10.);

run;

proc print;run;

proc contents; run;

Linlin

How to convert numeric date to sasdate ?

sasbasls — Fri, 06 Jan 2012 02:25:07 GMT

Thank you art297, it worked.

How to convert numeric date to sasdate ?

sasbasls — Fri, 06 Jan 2012 02:25:29 GMT

Thank you too.

Re: How to convert numeric date to sasdate ?

art297 — Fri, 06 Jan 2012 02:29:35 GMT

p.s. Linlin .. Thanks for correcting my typo!

Re: How to convert numeric date to sasdate ?

Linlin — Fri, 06 Jan 2012 12:20:41 GMT

Hi Art,

you are more than welcome. Thank you for your contribution to the forum. I have learned a lot from you.

Linlin