BookmarkSubscribeRSS Feed
☑ This topic is solved. Need further help from the community? Please sign in and ask a new question.
SASdevAnneMarie
Barite | Level 11

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 !

 

 

1 ACCEPTED SOLUTION

Accepted Solutions
Ksharp
Super User
%let Ma_Date_time = %sysfunc(compress(%sysfunc(datetime(),e8601dt.),T-: ));

%put &=Ma_Date_time ;

View solution in original post

4 REPLIES 4
Kurt_Bremser
Super User

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
Super User
%let Ma_Date_time = %sysfunc(compress(%sysfunc(datetime(),e8601dt.),T-: ));

%put &=Ma_Date_time ;
SASdevAnneMarie
Barite | Level 11
Thank you,
What means T-:, please ?
Ksharp
Super User
It get rid of characters " T - : " .

How to Concatenate Values

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.

SAS Training: Just a Click Away

 Ready to level-up your skills? Choose your own adventure.

Browse our catalog!

Discussion stats
  • 4 replies
  • 1325 views
  • 4 likes
  • 3 in conversation