How to convert date string to SAS date?

[caveman529]

Ladies and Gentlemen:

I have a variable in my dataset that is text string as below.  I hope to transfer them to SAS date.

date_have

------------

Dec-31-2008

Mar-31-2009

Mar-31-2009

Jun-30-2009

I tried the following, but it doesn't work.

date_want = input(substr(strip(date_have),1,10),MMDDYY10.);

Any suggestions?  Thanks -

[LinusH]

MMDDYY. informat requires month specified as a number - see the documentation.

You need another informat...

[caveman529]

I tried anydate11. , it seems to work for now.

Thanks-

[pradeepalankar]

data test;

input date_have $11.;

format date_sas date9.;

date_sas=input(cats(scan(date_have,2,'-'),scan(date_have,1,'-'),scan(date_have,3,'-')),date9.);

cards;

Dec-31-2008

Mar-31-2009

Mar-31-2009

Jun-30-2009

;

run;

[DR_Majeti]

Hi,

ANYDTDTEw. 

Reads and extracts the date value from any  of the following: DATE, DATETIME, DDMMYY, JULIAN, MDYAMPM, MMDDYY, MMxYY*,

MONYY, TIME, YMDDTTM, YYMMDD, YYQ, YYxMM*, month-day-year

Try anydtdte11. in your case.