I need to concatenate the following text strings from multiple records in a variable Var1
Var1
01
02
03
04
.
.
into something like
"01", "02", "03", "04", ......
and store this long string in a macro variable.
Is there an easy way to do it?
Thanks.
Use SQL and into with separated by option. Note that the quotes are: single, double, comma, double, single. Also that the first and end quotes are missing, but you can easily get around that by including them in your query.
Proc SQL noprint;
select name into :name_list separated by '" , "'
from sashelp.class;
quit;
%put &name_list;
%put "&name_list";
QUOTE function
Thank you both! It works!
Don't miss out on SAS Innovate - Register now for the FREE Livestream!
Can't make it to Vegas? No problem! Watch our general sessions LIVE or on-demand starting April 17th. Hear from SAS execs, best-selling author Adam Grant, Hot Ones host Sean Evans, top tech journalist Kara Swisher, AI expert Cassie Kozyrkov, and the mind-blowing dance crew iLuminate! Plus, get access to over 20 breakout sessions.
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.