Date

[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;

[sbxkoenk · Accepted solution]

Hello,

as "E8601DT26.6" is a date-time format (date + time) you need to extract the datepart from DT_CURRENT in order to be able to successfully use the monyy5. format :

datepart(DT_CURRENT) format=monyy5.

Koen

[Tom]

Looks like you have only one DATE variable. The other one is a DATETIME variable.  Date values are stored as number of days. Datetime values are stored as number of seconds.  So you cannot use the same format to display both of them.  But you could use the DTMONYY5. format to display the datetime value in the same MONYY style.

PS Why are you displaying only two of the four digits of the year?  That can cause confusion about which century the values represent.