topic Re: Date in Statistical Procedures

Date

Thalitacosta — Fri, 19 Nov 2021 13:19:12 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

sbxkoenk — Fri, 19 Nov 2021 15:46:45 GMT

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

Re: Date

Tom — Fri, 19 Nov 2021 18:28:30 GMT

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.