I have the following:
Date
_1_2_14
_1_3_14
_1_6_14
_1_7_14
_1_8_14
_1_9_14
_1_10_14
and so on.....
and I want to convert it to a date. How can I do that?
Thanks for all the help!
is you date month day year or day month year? Can't tell from the example.
data junk;
input datestr :$9.;
date=mdy((scan(datestr,1,'_')),(scan(datestr,2,'_')),(scan(datestr,3,'_')));
format date mmddyy10.;
datalines;
_1_2_14
_1_3_14
_1_6_14
_1_7_14
_1_8_14
_1_9_14
_1_10_14
;
run;
works for month day year if you don't mind warnings about character to numeric conversion.
Hello letsdoit,
Maybe try:
data want;
length
cdate $9;
format
date ddmmyys10.;
input
cdate $;
cdate=tranwrd(substr(cdate,2),'_','/');
date=input(cdate,ddmmyy9.);
drop
cdate;
datalines;
_1_2_14
_1_3_14
_1_6_14
_1_7_14
_1_8_14
_1_9_14
_1_10_14
;
run;
Join us for SAS Innovate April 16-19 at the Aria in Las Vegas. Bring the team and save big with our group pricing for a limited time only.
Pre-conference courses and tutorials are filling up fast and are always a sellout. Register today to reserve your seat.
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.