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
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;
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
Build your skills. Make connections. Enjoy creative freedom. Maybe change the world. Registration is now open through August 30th. Visit the SAS Hackathon homepage.
Register today!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.
Select SAS Training centers are offering in-person courses. View upcoming courses for: