SAS Date Function

[skallamp]

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

[DeepakSwain]

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;

[Astounding · Accepted solution]

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.

[DeepakSwain]

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

[Astounding]

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.