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.
Don't miss out on SAS Innovate - Register now for the FREE Livestream!
Can't make it to Vegas? No problem! Watch our general sessions LIVE or on-demand starting April 17th. Hear from SAS execs, best-selling author Adam Grant, Hot Ones host Sean Evans, top tech journalist Kara Swisher, AI expert Cassie Kozyrkov, and the mind-blowing dance crew iLuminate! Plus, get access to over 20 breakout sessions.
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.