topic Re: SAS Date Function in SAS Programming

SAS Date Function

skallamp — Tue, 21 Jun 2016 20:22:12 GMT

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

Re: SAS Date Function

DeepakSwain — Tue, 21 Jun 2016 20:46:00 GMT

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;

Re: SAS Date Function

Astounding — Tue, 21 Jun 2016 20:58:37 GMT

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.

Re: SAS Date Function

DeepakSwain — Wed, 22 Jun 2016 13:46:43 GMT

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

Re: SAS Date Function

Astounding — Wed, 22 Jun 2016 14:53:46 GMT

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.