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;
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.