topic Re: How to use macro with multiple quotation marks in pass-through? in SAS Programming

How to use macro with multiple quotation marks in pass-through?

schoi — Mon, 20 Nov 2017 22:27:12 GMT

I have a macro with multiple quotation marks. For example,

%let animal = 'cow', 'pig', 'chicken'

I want to use the macro animal in the WHERE clause in a proc sql pass-through query. How do I do that?

I already tried bquote and str but it doesn't seem to work.

Thanks

Re: How to use macro with multiple quotation marks in pass-through?

Astounding — Mon, 20 Nov 2017 22:59:28 GMT

You don't need any functions. Anywhere in the program where this would be valid syntax:

'cow', 'pig', 'chicken'

just insert &ANIMAL at that point.

Re: How to use macro with multiple quotation marks in pass-through?

Tom — Mon, 20 Nov 2017 23:05:16 GMT

Did you try it? What problem did you have?

%let animal = 'cow', 'pig', 'chicken' ;
proc sql ;
 connect to oracle as mydb ..... ;
select * from connection to mydb
(select * from have
  where animal in (&animal)
);
quit;

Re: How to use macro with multiple quotation marks in pass-through?

schoi — Tue, 21 Nov 2017 16:48:49 GMT

Thanks everyone. It actually works. There was something wrong with my logic in my code that made me think it wasn't working.