topic Re: Reading date containing multiple delimiters in SAS Programming

Reading date containing multiple delimiters

knveraraju91 — Fri, 02 Jun 2017 23:18:53 GMT

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;

Re: Reading date containing multiple delimiters

Reeza — Sat, 03 Jun 2017 00:18:09 GMT

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;

Re: Reading date containing multiple delimiters

art297 — Sat, 03 Jun 2017 00:54:40 GMT

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