topic Re: Looking for a datetime format in SAS Programming

Looking for a datetime format

SASdevAnneMarie — Wed, 22 Feb 2023 09:12:31 GMT

Hello Expert,

My actual code is :

%let Ma_Date_time = %sysfunc(datetime(),datetime22.);

The result is 22FEB2023:10:03:19

Do you know, please, the datetime format for the result : 20230222100319? (YearMonthDayHhMmSs)

Thank you !

Kurt_Bremser — Wed, 22 Feb 2023 09:34:29 GMT

If you could live with the T between date and time, I would recommend the B8601DT format. Otherwise, roll your own picture format:

proc format;
picture dhmsn /* "n" for "no delimiter" ;) */
  low-high = '%Y%0m%0d%0H%0M%0S' (datatype=datetime)
;
run;

Ksharp — Wed, 22 Feb 2023 11:49:58 GMT

%let Ma_Date_time = %sysfunc(compress(%sysfunc(datetime(),e8601dt.),T-: ));

%put &=Ma_Date_time ;

SASdevAnneMarie — Mon, 27 Feb 2023 08:38:54 GMT

Thank you,
What means T-:, please ?

Ksharp — Mon, 27 Feb 2023 12:01:29 GMT

It get rid of characters " T - : " .