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 -
MMDDYY. informat requires month specified as a number - see the documentation.
You need another informat...
I tried anydate11. , it seems to work for now.
Thanks-
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;
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.
Available on demand!
Missed SAS Innovate Las Vegas? Watch all the action for free! View the keynotes, general sessions and 22 breakouts on demand.
Learn how use the CAT functions in SAS to join values from multiple variables into a single value.
Find more tutorials on the SAS Users YouTube channel.