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!
Join us for SAS Innovate April 16-19 at the Aria in Las Vegas. Bring the team and save big with our group pricing for a limited time only.
Pre-conference courses and tutorials are filling up fast and are always a sellout. Register today to reserve your seat.
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.