Using macro for proc sql with single and double quotes,error

[Tom]

You can also just make your own macro to add the single quotes. 

[AhmedAl_Attar]

Try this

%macro temp(val=x);

   %local quotedVal;

   %let quotedVal = %str(%')&val%nrstr(%%%');

   proc sql;

      select * from table1 where col1 like %unquote(&quotedVal); /* %superq(quotedVal) would cause SQL syntax Error! */

   quit;

%mend;

options mprint;

%temp(val=x);

[JakobHommelhoff]

I have had the same problem...

Try this...

%macro temp(val=x);

     proc sql;

          select * from table1 where col1 like "%QOUTE(%%)&val.%";

     quit;

%mend;

[Ksharp]

That is weird . Your code should be work.

Try:

Code: Program

data table1;
col1='xdw';y1=2;output;
col1='ddw';y1=2;output;
run;


%macro temp(val=x);
proc sql;
select * from table1 where col1 eqt symget('val');
quit;
%mend;

%temp

Xia Keshan