Passing macro with quotes to Oracle server

ammarhm — Tue, 08 Jan 2019 22:03:56 GMT

I am trying to pass a string using a macro variable to an oracle server to extract data. The string will serve as a Where string. THe final product should be passed to the Oracle server like this

Select *
from DB
where column in ('A', 'B')
quit
;

However, i need the column variable to be passed in using a macro variable. Here is what I am trying to solve it:

%let column="('A','B')";

Select *
from DB
where column in %bquote(&column)
quit
;

This is however generating an error, which is mostly related to the quotes I think. I tried %unquote but no luck.

Anyone has a solution to this please?

Re: Passing macro with quotes to Oracle server

novinosrin — Tue, 08 Jan 2019 22:07:01 GMT

Why are wrapping your macro variable with double quotes

I don't think this

%let column="('A','B')";

is needed.

The following should suffice

%let column=('A','B');

topic Re: Passing macro with quotes to Oracle server in SAS Programming

Passing macro with quotes to Oracle server

Re: Passing macro with quotes to Oracle server