DATE FORMAT

[Thalitacosta]

I have two date variables that I need to format the variable "dt" has the "DDMMYY10." format; and the variable "dt_current" has the "E8601DT26.6" format. When I do the code below, the variable "dt_current" does not return the format I want. What format should I use? proc sql; create table NV2 as select DT format=monyy5., DT_CURRENT format=monyy5. from NV1; quit;

[PaigeMiller · Accepted solution]

When I do the code below, the variable "dt_current" does not return the format I want.

From now on, when you are not getting the desired result, please SHOW US what you are getting, and explain what you want. From now on, don't make us ask to see what you are getting; show us before we ask.