Reading date containing multiple delimiters

[knveraraju91]

Dear,

i am using the below program to read the dates in data one. Please suggest any other way to convert the dates. Thank you.

data one;
input date $11.;
datalines;
Oct//5/2012
Jan/20/2012
;

data two;
set one;
date2=put(input(strip(scan(date,2,'/'))||strip(scan(date,1,'/'))||strip(scan(date,3,'/')),date9.),is8601da.);
run;

[Reeza]

I would read each component and reassemble. 

data one;
infile cards dlm='/';
input month $ day year;

date = input(catt(day, month, year), date9.);
format date date9.;

datalines;
Oct//5/2012
Jan/20/2012
;
run;

[art297]

The anydtdte informat is quite forgiving:

data one;
  input date anydtdte15.;
  format date date9.;
  datalines;
Oct//5/2012
Jan/20/2012
;

Art, CEO, AnalystFinder.com