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