Concatenating column values into macro variable

[A_SAS_Man]

I am attempting to concatenate all values in a column into one macro variable with some additional characters. Here is what I'm starting with.

data have;
input test_values :$2.;
datalines;
AB
BC
CD
DE
EF
;

What I would like is for the values to be stored in a macro with the following structure. Assuming we were storing into a macro variable named test and I ran

%put &test; 

I would like to see the following:

'AB','BC','CD','DE','EF'

I have been trying to use some variation of the following to do it, but haven't been successful yet.

proc sql noprint;
select test_values into: test separated by ','
from have;
quit;

[PaigeMiller · Accepted solution]

Let the QUOTE() function have all the fun.

proc sql noprint;
select quote(test_values,"'") into: test separated by ','
from have;
quit;

[ballardw]

Depending on the defined length of the text variable you may need: quote(strip(test_values),"'") to avoid trailing blanks inside the quotes for any value not the full defined length of the variable.

[Tom]

You normally would not want to use STRIP().  That will remove both leading and trailing spaces.  SAS comparisons normally ignore trailing spaces, but leadings spaces it considers meaningful.  So use TRIM() instead.

[Peter_C]

alternatively
select test_values format= $quote200. into: test separated by ','

deals with trailing spaces as required and highlights that we can apply useful formats when SELECT-ing INTO :macrovars