How to convert date string to SAS date?

Reply
Regular Contributor
Posts: 161

How to convert date string to SAS date?

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 -

Super User
Posts: 5,438

Re: How to convert date string to SAS date?

Posted in reply to caveman529

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

You need another informat...

Data never sleeps
Regular Contributor
Posts: 161

Re: How to convert date string to SAS date?

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

Thanks-

Frequent Contributor
Posts: 106

Re: How to convert date string to SAS date?

Posted in reply to caveman529

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;

Contributor
Posts: 64

Re: How to convert date string to SAS date?

Posted in reply to caveman529

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.

Ask a Question
Discussion stats
  • 4 replies
  • 597 views
  • 3 likes
  • 4 in conversation