topic Re: DATE FORMAT in Statistical Procedures

DATE FORMAT

Thalitacosta — Fri, 19 Nov 2021 13:22:02 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" returns missing. 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:32:48 GMT

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.