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 ;
April 27 – 30 | Gaylord Texan | Grapevine, Texas
Walk in ready to learn. Walk out ready to deliver. This is the data and AI conference you can't afford to miss.
Register now and lock in 2025 pricing—just $495!
Still thinking about your presentation idea? The submission deadline has been extended to Friday, Nov. 14, at 11:59 p.m. ET.
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.
Ready to level-up your skills? Choose your own adventure.