DATA Step, Macro, Functions and more

SAS Date Function

Accepted Solution Solved
Reply
Contributor
Posts: 32
Accepted Solution

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: 5,516

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.

 

 

 

 

View solution in original post


All Replies
Frequent Contributor
Posts: 104

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: 5,516

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: 104

Re: SAS Date Function

Posted in reply to Astounding

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: 5,516

Re: SAS Date Function

Posted in reply to DeepakSwain

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.

Need further help from the community? Please ask a new question.

Discussion stats
  • 4 replies
  • 332 views
  • 3 likes
  • 3 in conversation