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

[schoi]

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

[Astounding]

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.

[Tom]

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;

[schoi]

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