topic Re: today's date and time are showing 01jan1960 in SAS Customer Intelligence

today's date and time are showing 01jan1960

RDS2020 — Thu, 15 Apr 2021 12:06:02 GMT

Hi,

I am doing below for today's time and date.

%let dt1= %sysfunc(putn(%eval(%sysfunc(today())-1),datetime.));

%put &dt1;

This is showing below date - 01JAN60:06:13:04

How can i get current TIME that also with leading zero in case it is single digit.

Thanks

Re: today's date and time are showing 01jan1960

PaigeMiller — Thu, 15 Apr 2021 12:20:18 GMT

Use format date. instead of datetime.

Re: today's date and time are showing 01jan1960

Kurt_Bremser — Thu, 15 Apr 2021 12:21:19 GMT

Dates are counts of days, while times and datetimes are counts of seconds. With 1960-01-01T00:00:00 as the zero point, today's date value (22385) will show up as a datetime sometime on 1960-01-01.

How you format the value (or not) depends on the further use. If you do not need it for display, the raw value is best, as you can then use the macro variable without further ado:

%let dt1=%sysevalf(%sysfunc(datetime())-86400);

%put &=dt1.;

data want;
set have;
if datetimevalue le &dt1.;
run;

With DATETIME(), you will get time down to microseconds, so you need to use %SYSEVALF to cope with the fraction.

Re: today's date and time are showing 01jan1960

Tom — Thu, 15 Apr 2021 13:12:16 GMT

TODAY() is just an alias for DATE() which returns a date value (number of days) not a datetime value (number of seconds).

To get the current datetime value use DATETIME() function instead of DATE() function. To have the string formatted properly use at least a width of 19 in the format specification, otherwise you will get only two digits for the year.

%let dt1= %sysfunc(intnx(dtday,%sysfunc(datetime()),-1,s),datetime19.);

To get the current time of day (seconds since midnight) use the TIME() function. To format it with leading zeros use the TOD format.

Re: today's date and time are showing 01jan1960

RDS2020 — Thu, 15 Apr 2021 22:18:08 GMT

Thanks for replying. What about the Time part of it . I would need time part with leading zero if its single digit

Re: today's date and time are showing 01jan1960

PaigeMiller — Thu, 15 Apr 2021 23:28:15 GMT

%let dt1= %sysfunc(putn(%eval(%sysfunc(today())-1),datetime.));

There is no time associated with today()

Or, trivially, the time associated with today() is 00:00:00.

So what do you want from today()?