data date;
input day month year;
date = mdy(day, month, year);
format date mmddyy10.;
datalines;
25 12 2005
21 10 1946
;
proc print data=date;
run;
Last I checked there isn't a month number 25. The letters in the MDY() function stand for Month,Day,Year.
mdy(month, day, year)
@b384b7 wrote:
But the months are 12 and 10.. right?
If you call MDY(25,x,y) then the MONTH is 25.
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.