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?
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');
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');
Available on demand!
Missed SAS Innovate Las Vegas? Watch all the action for free! View the keynotes, general sessions and 22 breakouts on demand.
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.