topic Re: How to convert date string to SAS date? in SAS Programming

How to convert date string to SAS date?

caveman529 — Tue, 28 Jan 2014 16:28:04 GMT

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

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 — Tue, 28 Jan 2014 16:36:47 GMT

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

You need another informat...

caveman529 — Tue, 28 Jan 2014 17:03:54 GMT

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

Thanks-

pradeepalankar — Tue, 28 Jan 2014 17:05:24 GMT

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

Jun-30-2009

;

run;

DR_Majeti — Wed, 05 Feb 2014 06:12:28 GMT

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.