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;
Are you ready for the spotlight? We're accepting content ideas for SAS Innovate 2025 to be held May 6-9 in Orlando, FL. The call is open until September 25. Read more here about why you should contribute and what is in it for you!
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.