Macro for todays date and time

[meckarthik]

Hi,

I want to create macro for processing date with time something like 

%let processdt = %sysfunc(today(), datetimeformat);

%put &processdt;

the output should be 2019-08-01 00:00:00.0

[PeterClemmensen]

data _null_;  
    dt=dhms(today(),0,0,0);;
    put dt= datetime18.;
run;

[Kurt_Bremser]

Take note of Maxim 28. In most cases, such macro variables need no format.

[data_null__]

---

@meckarthik wrote:

Hi,

I want to create macro for processing date with time something like 

%let processdt = %sysfunc(today(), datetimeformat);

%put &processdt;

the output should be 2019-08-01 00:00:00.0

---

9    %put NOTE: %sysfunc(datetime(),E8601LX20);
NOTE:  2019-08-01T08:53:14

19   %put NOTE: %sysfunc(datetime(),E8601LX22.1);
NOTE:  2019-08-01T08:56:22.2

Pretty close I think you need the T.  

[novinosrin]

data _null_;
processdt =datetime()-time();
/* write your call symputx here and store in global symbol table*/
put processdt=;
format processdt e8601dt25.;
run;

[Reeza · Accepted solution]

proc format;
picture dtStamp (round) 
low - high = '%Y-%0m-%0d %0H:%0M:%0S.%s' (datatype=datetime);
run;

%put NOTE: %sysfunc(datetime(), dtStamp.);

Here's the roll your own format options, dtStamp is the format name.

---

@meckarthik wrote:

Hi,

I want to create macro for processing date with time something like 

%let processdt = %sysfunc(today(), datetimeformat);

%put &processdt;

the output should be 2019-08-01 00:00:00.0

---