Need solution for the below dataset

[sasuser1]

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?

[DBailey]

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.

[Linlin]

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;

[Reeza]

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;