One of my SAS data set gives the date in below format(Datetime24.3)
How do I convert this to MMDDYY format?
Date
10Sep2015:13:39:08.000
10Sep2015:13:45:08.000
10Sep2015:15:20:08.000
It depends on whether your original variable is a numeric SAS date, or a character string. For a numeric SAS date:
date = datepart(date);
For a character string, a good suggestion has already been posted. However, note that it could be simplified. WIthin the context of that earlier suggestion:
date1 = input(date2, date9.);
Either way, apply the FORMAT statement to the resulting variable.
Hi there,
I have make a simple try. It might work for you.
data test1;
input date1 $22.;
datalines;
10Sep2015:13:39:08.000
10Sep2015:13:45:08.000
10Sep2015:15:20:08.000
;
run;
data test2;
set test1 (rename=(date1=date2));
date1=input(substr(date2, 1, 9), date9.);
format date1 MMDDYY10. ;
drop date2;
run;
It depends on whether your original variable is a numeric SAS date, or a character string. For a numeric SAS date:
date = datepart(date);
For a character string, a good suggestion has already been posted. However, note that it could be simplified. WIthin the context of that earlier suggestion:
date1 = input(date2, date9.);
Either way, apply the FORMAT statement to the resulting variable.
Hi Astounding,
Based on your guidance, I have updated the sas code for numeric sas date as :
data test1;
input date1 $22.;
datalines;
10Sep2015:13:39:08.000
10Sep2015:13:45:08.000
10Sep2015:15:20:08.000
;
run;
data test2;
set test1 (rename=(date1=date2));
date3=input(date2, datetime24.3);
date1=datepart(date3);
format date1 MMDDYY10.;
drop date2 date3;
run;
Regards,
Deepak
Note that you could have gone directly from date1 to date2:
date2 = input(date1, date9.);
The DATE9 informat instructs the software to reach the first 9 characters of DATE1, when calculating DATE2.
SAS Innovate 2025 is scheduled for May 6-9 in Orlando, FL. Sign up to be first to learn about the agenda and registration!
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.
Ready to level-up your skills? Choose your own adventure.