topic Re: SYSDATE and SYSTIME in SAS Programming

SYSDATE and SYSTIME

mlogan — Fri, 27 May 2016 01:33:53 GMT

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

Re: SYSDATE and SYSTIME

Reeza — Fri, 27 May 2016 02:48:07 GMT

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;

Re: SYSDATE and SYSTIME

LinusH — Fri, 27 May 2016 05:17:59 GMT

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

Re: SYSDATE and SYSTIME

mlogan — Fri, 27 May 2016 15:28:14 GMT

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;

Re: SYSDATE and SYSTIME

mlogan — Fri, 27 May 2016 15:32:26 GMT

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

Re: SYSDATE and SYSTIME

LinusH — Fri, 27 May 2016 15:45:29 GMT

Long_char="&long_char";