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 !
%let Ma_Date_time = %sysfunc(compress(%sysfunc(datetime(),e8601dt.),T-: )); %put &=Ma_Date_time ;
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;
%let Ma_Date_time = %sysfunc(compress(%sysfunc(datetime(),e8601dt.),T-: )); %put &=Ma_Date_time ;
Don't miss out on SAS Innovate - Register now for the FREE Livestream!
Can't make it to Vegas? No problem! Watch our general sessions LIVE or on-demand starting April 17th. Hear from SAS execs, best-selling author Adam Grant, Hot Ones host Sean Evans, top tech journalist Kara Swisher, AI expert Cassie Kozyrkov, and the mind-blowing dance crew iLuminate! Plus, get access to over 20 breakout sessions.
Learn how use the CAT functions in SAS to join values from multiple variables into a single value.
Find more tutorials on the SAS Users YouTube channel.