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.
Are you ready for the spotlight? We're accepting content ideas for SAS Innovate 2025 to be held May 6-9 in Orlando, FL. The call is open until September 25. Read more here about why you should contribute and what is in it for you!
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.