BookmarkSubscribeRSS Feed
JasonL
Quartz | Level 8

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.

3 REPLIES 3
Reeza
Super User

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";

data_null__
Jade | Level 19

QUOTE function

18         Proc SQL noprint;
19            select quote(strip(name)) into :name_list separated by ','
20            from sashelp.class;
21            quit;
22            run;
23         %put NOTE: &=name_list;
NOTE:
NAME_LIST=
"Alfred","Alice","Barbara","Carol","Henry","James","Jane","Janet","Jeffrey","John","Joyce","Judy","Louise","Mary","Philip"
,
"Robert","Ronald","Thomas","William"
JasonL
Quartz | Level 8

Thank you both!  It works!

sas-innovate-2024.png

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.

 

Register now!

How to Concatenate Values

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.

Click image to register for webinarClick image to register for webinar

Classroom Training Available!

Select SAS Training centers are offering in-person courses. View upcoming courses for:

View all other training opportunities.

Discussion stats
  • 3 replies
  • 505 views
  • 1 like
  • 3 in conversation