topic proc sql Into to create macr var with double quotes " " in SAS Programming

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

Ronein — Sun, 15 Mar 2020 09:26:55 GMT

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" */

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

ed_sas_member — Sun, 15 Mar 2020 09:34:58 GMT

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,

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

Kurt_Bremser — Sun, 15 Mar 2020 09:36:24 GMT

Use the QUOTE() function.