Data abc;
input start_date $10.;
cards;
2008-06-31
;
run;
I am trying to convert the about date into the date format 31/06/2008.
Could you please any one help in getting this resolved?
I don't think that's a valid date? If it was, it should be a simple matter to read it in as a date and apply the ddmmyy10. format.
Hi,
there were only 30 days in June.
Data abc;
input start_date $10.;
cards;
2008-06-30
;
data want;
set abc;
new_date=input(start_date,yymmdd10.);
format new_date ddmmyy10.;
proc print;run;
Or directly in the input step is possible.
Data abc;
informat start_date yymmdd10.;
format start_date date9.;
input start_date;
cards;
2008-06-30
2008-06-31
2008-07-01
;
run;
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.