topic datetime format in sas ddmmyyhhmmss in SAS Programming

datetime format in sas ddmmyyhhmmss

sathya66 — Tue, 03 Oct 2023 09:07:46 GMT

Hi Al,

I am able to get the datatime in the ddmmyyhhmmss format but 0 is missing at start

output :-3102023100202

but looking for :- 03102023100202

%let now=%sysfunc(datetime());
%let date_time = %sysfunc(inputn(%sysfunc(putn(%sysfunc(datepart(&now)),DDMMYYN8.)),8.))%sysfunc(timepart(&now),B8601TM6);
%put  &date_time.;

Thanks,

Re: datetime format in sas ddmmyyhhmmss

LinusH — Tue, 03 Oct 2023 10:58:33 GMT

You put the result in a numerical variable, and the default behavior implicit leading zeroes are not displayed.

Maybe it would be better keep your value as a SAS datetime value, and have custom format to display it according to your requirements?

https://documentation.sas.com/doc/en/pgmsascdc/v_043/proc/p0n990vq8gxca6n1vnsracr6jp2c.htm

Re: datetime format in sas ddmmyyhhmmss

PaigeMiller — Tue, 03 Oct 2023 11:16:57 GMT

%let date_time=%sysfunc(putn(%sysfunc(datepart(&now)),ddmmyyn8.))%sysfunc(timepart(&now),B8601TM6);

No need for PUTN in the above creation of macro variable &DATE_TIME

Re: datetime format in sas ddmmyyhhmmss

Kurt_Bremser — Tue, 03 Oct 2023 11:08:13 GMT

For any technical use, I strongly (and I mean STRONGLY) advise against using a DMY date. Use YMD instead.

So I suggest

%let date_time = %sysfunc(compress(%sysfunc(datetime(),b8601dt15.),T));

Re: datetime format in sas ddmmyyhhmmss

LinusH — Tue, 03 Oct 2023 11:12:42 GMT

proc format;
	picture ddmmyyhhmmss
		low-high = '%0d%0m%Y%0H%0M%0S' (datatype=datetime);
run;

%let now = %sysfunc(datetime(),ddmmyyhhmmss.);
%put &now;