SYSDATE and SYSTIME

[mlogan]

Hi All,

I am trying to concatenate some character variables and one of those variable is SYS date and time. SYS date and time should be YYYY-MM-DD:hh:mm:ss format. Can someone help me please. Thanks.

The code i am trying to write is like:

DATA test;
Long_char='1234'||'ABCD'||System date and Time;
RUN;

Expected output:

Long_char=1234ABCD2016-02-09:15:41:29

[Reeza]

You can use datetime() function instead. My personal preference is to use the CATT function, I find it more readable.

%put %sysfunc(datetime(), datetime21.);

data want;
long_var = catt("1234", "ABCD", put(datetime(), datetime21.));
run;

proc print data=want;
run;

[mlogan]

Hi Reeza,
Thank you for the solution, but your code leave three spaces between third character and the date. Also it doesn't show (-) in between (like YYYY-MM-DD). I want it like 2016-02-09:15:41:29. can you please help further. Thanks.

%put %sysfunc(datetime(), datetime21.);

DATA have;
long_char='T1'||'12345'||'000000000000'||put(datetime(), datetime21.);
RUN;

[LinusH]

%Let long_char=1233ABCD%sysfunc(today(),yymmdd10.):%sysfunc(time(),time.);

[mlogan]

Hi LinusH,
Thank for your code, but I don't know how to put it in the data step. Would you please put your code in the following data step so that I can get my expected result. I never worked with a let statement. Thanks.

DATA have;
long_char='1234'||'ABCD'||SYS date and SYS time;
RUN;

Expected output:

long_char=1234ABCD2016-02-09:15:41:29

[LinusH · Accepted solution]

Long_char="&long_char";