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');
Build your skills. Make connections. Enjoy creative freedom. Maybe change the world. Registration is now open through August 30th. Visit the SAS Hackathon homepage.
Register today!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.
Select SAS Training centers are offering in-person courses. View upcoming courses for: