title: how to reference a macro list in a filter of sas query editor
body: <p>Hello Stackoverflow community.</p>
  <p>I need to insert a filter into SAS Enterprise Guide query builder.</p>
  <p>This filter should contain a huge list of product codes, the format of this column is a character, but it's very time consuming to insert them one by one into the filter section using the IN operator.</p>
  <p>So I was thinking to create a sas macrovariable, and referencing it into the filter of the query builder. Below an example</p>
  <pre><code>%LET product_codes = 
  '815001004490'
  '815300465351',
  '815100001069',
  '815000000152',
  '815100000561'
  ;
  </code></pre>
  <p>I wrote a proc sql to check if the program was giving me back results, and I got what I was expecting</p>
  <pre><code>proc sql;
  create table want as 
  select * from library_name.table_name
  where product in (&amp;product_codes.)
  ;
  quit;
  </code></pre>
  <p>However, when I repeat the same process in SAS query editor, then I get back an empty table.
  <a href="https://i.stack.imgur.com/1zvNN.png" rel="nofollow noreferrer"><img src="https://i.stack.imgur.com/1zvNN.png" alt="enter image description here" /></a></p>
  <p>I guess I am missing something. I am aware that the macrovariable works as simple text generator. How can this be resolved? any ideas? what am I doing wrong.</p>