topic Re: DATE FORMAT in Statistical Procedures

DATE FORMAT

Thalitacosta — Fri, 19 Nov 2021 13:51:03 GMT

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;

Re: DATE FORMAT

PaigeMiller — Fri, 19 Nov 2021 13:59:04 GMT

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.