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" returns missing. 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]

First, please look at the data yourself, and make sure the values of DT_CURRENT in data set NV1 are not missing.

If they are not missing, please show us some examples of the value of this variable DT_CURRENT.