BookmarkSubscribeRSS Feed
schoi
Calcite | Level 5

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

3 REPLIES 3
Astounding
PROC Star

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
Super User Tom
Super User

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
Calcite | Level 5

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

sas-innovate-2024.png

Join us for SAS Innovate April 16-19 at the Aria in Las Vegas. Bring the team and save big with our group pricing for a limited time only.

Pre-conference courses and tutorials are filling up fast and are always a sellout. Register today to reserve your seat.

 

Register now!

How to Concatenate Values

Learn how use the CAT functions in SAS to join values from multiple variables into a single value.

Find more tutorials on the SAS Users YouTube channel.

Click image to register for webinarClick image to register for webinar

Classroom Training Available!

Select SAS Training centers are offering in-person courses. View upcoming courses for:

View all other training opportunities.

Discussion stats
  • 3 replies
  • 676 views
  • 0 likes
  • 3 in conversation