proc sql Into to create macr var with double quotes " "

[Ronein]

Hello

I create a macro var that will get multiple values with comma between them.

I want to add double quotes ""  for each value in macro var.

what is the way to do it please?

Data example;
input x $;
cards;
USA
EU
JAPAN
CHINA
PERU
;
Run;

proc sql noprint;
select x  into :v separated by ','
from  example  
;
quit;
%put &v.;
/*USA,EU,JAPAN,CHINA,PERU*/
/* I want to get values:  "USA","EU","JAPAN","CHINA","PERU" */

[ed_sas_member · Accepted solution]

HI @Ronein 

You can use the QUOTE() function to achieve this:

Data example;
input x $;
cards;
USA
EU
JAPAN
CHINA
PERU
;
Run;

proc sql noprint;
select quote(trim(x),"")  into :v separated by ','
from  example  
;
quit;
%put &v.;

Best,

[Kurt_Bremser]

Use the QUOTE() function.