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;
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;
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
Don't miss out on SAS Innovate - Register now for the FREE Livestream!
Can't make it to Vegas? No problem! Watch our general sessions LIVE or on-demand starting April 17th. Hear from SAS execs, best-selling author Adam Grant, Hot Ones host Sean Evans, top tech journalist Kara Swisher, AI expert Cassie Kozyrkov, and the mind-blowing dance crew iLuminate! Plus, get access to over 20 breakout sessions.
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.