topic Re: dtdate format in SAS Programming

dtdate format

BrahmanandaRao — Sat, 11 Dec 2021 10:24:18 GMT

Hi guys

it shows 1jan1960 instead of today date

data w;
n=today(); 
format n  dtdate9.;
run;

Re: dtdate format

Kurt_Bremser — Sat, 11 Dec 2021 10:39:27 GMT

MAXIM 1: Read the Documentation!

From the documentation of the DTDATE format:

Expects a datetime value as input and writes date values in the form ddmmmyy or ddmmmyyyy.

(emphasis by me).

Re: dtdate format

Tom — Sat, 11 Dec 2021 16:24:14 GMT

@BrahmanandaRao wrote:

Hi guys

it shows 1jan1960 instead of today date
data w;
n=today(); 
format n  dtdate9.;
run;

SAS stores dates as number of days and datetime values as number of seconds.

What date do you think 22 thousand seconds into the year 1960 represents?

For a hint open this "spoiler".

424   data _null_;
425     days=date();
426     seconds=datetime();
427     put 'DAYS    ' (4*days) (comma15. +1 date9. +1 dtdate9. +1 tod8.);
428     put 'SECONDS ' (4*seconds) (comma15. +1 date9. +1 dtdate9. +1 tod8.);
429   run;

DAYS             22,625 11DEC2021 01JAN1960 06:17:05
SECONDS   1,954,840,911 ********* 11DEC2021 11:21:51