DATA Step, Macro, Functions and more

Reading date containing multiple delimiters

Reply
Super Contributor
Posts: 272

Reading date containing multiple delimiters

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;
Super User
Posts: 19,772

Re: Reading date containing multiple delimiters

Posted in reply to knveraraju91

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;
PROC Star
Posts: 7,468

Re: Reading date containing multiple delimiters

Posted in reply to knveraraju91

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

Ask a Question
Discussion stats
  • 2 replies
  • 174 views
  • 3 likes
  • 3 in conversation