topic Re: Macro for todays date and time in New SAS User

Macro for todays date and time

meckarthik — Thu, 01 Aug 2019 15:38:22 GMT

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

Re: Macro for todays date and time

PeterClemmensen — Thu, 01 Aug 2019 15:53:16 GMT

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

Re: Macro for todays date and time

Kurt_Bremser — Thu, 01 Aug 2019 15:55:13 GMT

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

Re: Macro for todays date and time

data_null__ — Thu, 01 Aug 2019 15:58:44 GMT

@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.

Re: Macro for todays date and time

novinosrin — Thu, 01 Aug 2019 16:10:01 GMT


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

Re: Macro for todays date and time

Reeza — Thu, 01 Aug 2019 16:30:56 GMT

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