DATETIME20. to MMDDYY10.

[amanda_cr]

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."

[RW9 · Accepted solution]

Hi,

You want the datepart() function:

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

[amanda_cr]

Awesome. That works perfectly!

Thank you, RW9.