topic Re: DATETIME20. to MMDDYY10. in SAS Data Management

DATETIME20. to MMDDYY10.

amanda_cr — Tue, 07 Mar 2017 15:37:55 GMT

Hi,

This is a really simple problem, but I can't seem to find a solution.

My date variable is in an informat and format of DATETIME20. I want it to be in a MMDDYY10. format. How do I change my date variable from a DATETIME20. to MMDDYY10. format? I want my date variable that looks like this "01FEB2016:00:00:00" to look like this "02/01/2016."

Re: DATETIME20. to MMDDYY10.

RW9 — Tue, 07 Mar 2017 15:50:10 GMT

Hi,

You want the datepart() function:

data want;
  thedt="01FEB2016:00:00:00"dt;
  thedt=datepart(thedt);
  format thedt mmddyy10.;
run;

Re: DATETIME20. to MMDDYY10.

amanda_cr — Tue, 07 Mar 2017 16:09:42 GMT

Awesome. That works perfectly!

Thank you, RW9.