Solved
Contributor
Posts: 32

# SAS Date Function

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

Accepted Solutions
Solution
‎06-22-2016 10:45 AM
Super User
Posts: 6,785

## Re: SAS Date Function

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.

All Replies
Frequent Contributor
Posts: 120

## Re: SAS Date Function

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;

Swain
Solution
‎06-22-2016 10:45 AM
Super User
Posts: 6,785

## Re: SAS Date Function

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.

Frequent Contributor
Posts: 120

## Re: SAS Date Function

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

Swain
Super User
Posts: 6,785

## Re: SAS Date Function

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.

🔒 This topic is solved and locked.